Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i have date field,
eg:
Date
233.2323
554.5454
I want to convert this milliseconds to Date and Time format.
Date
12/04/2016 01:34:23 AM
14/05/2016 05:34:23 PM
I tried with all expressions, its not working. pls help me to find out.
Thanks
May be like this in your environmental variable
SET TimestampFormat='DD/MM/YYYY hh:mm:ss TT';
and then just TimeStamp(Date) as Date in the load statement
try below
how is 233.2323 becoming 12/04/2016? I might be missing something, but it would be great if you can elaborate and then we might be able to help better
Sorry, i haven't actually posted the exact milliseconds, that converts to 12/04/2016.
i meant that just as a sample.
May be like this in your environmental variable
SET TimestampFormat='DD/MM/YYYY hh:mm:ss TT';
and then just TimeStamp(Date) as Date in the load statement
Try using the below expression:
=Date(Date#(date,'ss.fff'),'M/D/YYYY h:mm:ss[.fff] TT')
or simply use
=Timestamp(date)