converting milliseconds to Date Time format

[Anonymous]

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

[Chanty4u]

try below

[sunny_talwar]

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

[Anonymous]

Sorry, i haven't actually posted the exact milliseconds, that converts to 12/04/2016.

i meant that just as a sample.

[sunny_talwar · Accepted solution]

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

[Jesh19]

Try using the below expression:

=Date(Date#(date,'ss.fff'),'M/D/YYYY h:mm:ss[.fff] TT')

or simply use

=Timestamp(date)