Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In my Load script,
(Modified_Date, 'YYYY-MM-DD hh:mm:ss') as Modified_Date
gets me the value 2014-08-12 16:03:31
but I need 2014-08-12 16:03:31.643
I would appreciate help...
Thanks
Original field is a datetime/timestamp: date(Modified_Date, 'YYYY-MM-DD hh:mm:ss.fff') as Modified_Date
Original field is a text value: tetime/timestamp: date#(Modified_Date, 'YYYY-MM-DD hh:mm:ss.fff') as Modified_Date
Original field is a datetime/timestamp: date(Modified_Date, 'YYYY-MM-DD hh:mm:ss.fff') as Modified_Date
Original field is a text value: tetime/timestamp: date#(Modified_Date, 'YYYY-MM-DD hh:mm:ss.fff') as Modified_Date
Hi,
try with Timestamp() and Timestamp#()
Like,
Timestamp(DateField, 'YYYY-MM-DD hh:mm:ss.fff')
Regards