datetime field is displaying decimal data while loading qvd

[#1]

Hi,

I have date fieldname having datetime datatype but when I load qvd data is dilsplaing with decimals not in date format.

how i load this data.Administrator

[#2 · Accepted solution]

Hi

Have you loaded the data as below;

timestamp( A,'YYYY-MM-DD hh.mm')

Where A is your data field.

Regards

Steve

[israrkhan]

Hi Pankaj.

use Date#() and Date() function in in load script to format the date accordingly.

read in help file about these functions.