MariaDB Table DateTime Column NULL Value its show "00"

[shri_fwh]

Dear Rao Sir ,

A MariaDB Table has DATETIME column and in the table there are null values for the column but in FiveWin Application its showing "00:00:000.000".

Please guide me for the same.

[nageswaragunupudi]

Yes, that is how we programmed.
NULL values are displayed as empty values of the corresponding data type.
This is makes it very easy to prepare Gets.

[shri_fwh]

Dear Rao Sir ,

Thanks a lot ...!

So I will make it "NIL" before displaying on the screen. The application displaying the values of creation / update date time as given below

Code: Select all  Expand view

   @260,  020  SAY  "Cr."           SIZE 040, C_SAYH PIXEL COLOR C_SAYFCLR, C_SAYBCLR FONT oApp:oFontSmall2 TRANSPARENT
   @280,  020  SAY  "Upd."           SIZE 040, C_SAYH PIXEL COLOR C_SAYFCLR, C_SAYBCLR FONT oApp:oFontSmall2 TRANSPARENT
   @260,  100  SAY  aVTxnS1[ IDX_TXNVOU_S1_CR_BY  ] SIZE 100, C_SAYSMALL_H2 PIXEL COLOR C_SAYFCLR, C_SAYBCLR FONT oApp:oFontSmall2  TRANSPARENT
   @260,  210  SAY  aVTxnS1[ IDX_TXNVOU_S1_CR_DT  ] SIZE 200, C_SAYSMALL_H2 PIXEL COLOR C_SAYFCLR, C_SAYBCLR FONT oApp:oFontSmall2  TRANSPARENT
   @280,  100  SAY  aVTxnS1[ IDX_TXNVOU_S1_UPD_BY ] SIZE 100, C_SAYSMALL_H2 PIXEL COLOR C_SAYFCLR, C_SAYBCLR FONT oApp:oFontSmall2  TRANSPARENT
   @280,  210  SAY  aVTxnS1[ IDX_TXNVOU_S1_UPD_DT ] SIZE 200, C_SAYSMALL_H2 PIXEL COLOR C_SAYFCLR, C_SAYBCLR FONT oApp:oFontSmall2 TRANSPARENT