Help with Data format

[#1]

Hi,

I have my date columns are showing up as below.. I tried to change the number format settings and used date(date#()) function..I need it to be displayed as MM/DD/YYYY HH:MM:SS.

Please advice.. Thanks in advance

[sunny_talwar · Accepted solution]

May be like this:

TimeStamp(TimeStamp#(Left(ReceivedDateTime, 14), 'YYYYMMDDhhmmss'), 'MM/DD/YYYY hh:mm:ss') as ReceivedDateTime

[engishfaque]

Dear Mohan,

Here it is,

inline_table:

LOAD Date(Timestamp#(Date, 'YYYYMMDDhhmmss'), 'MM/DD/YYYY hh:mm:ss') as Date Inline [

  Date

  20160418101110016

];

Kind regards,

Ishfaque Ahmed

[#4]

Thanks sunny and Ishfaque Ahmed.. Both worked for date in format "20160418101110016"  but didn't work for date in exponent form...