Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Just use
Date(max(Timestamp),'DD/MM/YYYY hh:mm:ss) as maxTS
Hi,
Use timestamp() instead of Timestamp#()
Regards
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;
Thank you, this worked.
Good!
Mark the answer as correct to close the thread.