DateTime Format

[#1]

Hi,

I'm trying to pull out the following:

load Timestamp#(max(Timestamp), 'DD/MM/YYYY hh:mm:ss')as maxTS
Resident ObsExportQVD;

However the result outs out as  42278.535208333  instead of '2015-10-02 08:10:15' for example.

I have also tried the following, and it bring outs the date in the correct format only. I need the time to come out as well.

load Date(max(Timestamp))as maxTS
Resident ObsExportQVD;

Any ideas how I can get around this?

Thank you.

[simenkg]

Just use

Date(max(Timestamp),'DD/MM/YYYY hh:mm:ss) as maxTS

[PrashantSangle]

Hi,

Use timestamp() instead of Timestamp#()

Regards

[maxgro]

if you want date use Date formatting function

load Date(max(Timestamp)) as maxTS
Resident ObsExportQVD;

if you want timestamp use the Timestamp formatting function

load Timestamp(max(Timestamp)) as maxTS Resident ObsExportQVD;

or add a format as second param in Timestamp

load Timestamp(max(Timestamp), 'the format you want') as maxTS Resident ObsExportQVD;

[#5]

Thank you, this worked.

[simenkg]

Good!

Mark the answer as correct to close the thread.