Date Timestamp

[rustyfishbones]

Hi All,

I have the following value - 2016-08-31 08:32:48:000 + 01:00

What is the best way to extract the date, I tried FLOOR and Date Function and it returns nothing.

I know I can try LEFT(DateTimeCreated,10) and that will return the date and I can then convert to DD/MM/YYYY instead of YYYY-MM-DD.

Any better methods to do this?

Thanks

Alan

[tresesco · Accepted solution]

If you use left() - a string function, it might not give you a real date (number at the back-end). You should rather use parsing function date#() alongwith it like and then format using date():

Date(Date#(LEFT(DateTimeCreated,10), 'YYYY-MM-DD'), 'DD/MM/YYYY ')

[rustyfishbones]

Thanks Tresesco