Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, I'm facing this issue:
I have a timestamp field of type 2019-01-01 23:59:59.997 and I need to extract the time from this field but when I try with Timestamp#(MyField, 'YYYY-MM-DD hh:mm:ss.fff') for convert MyField in a number, the result is the same field 2019-01-01 23:59:59.997.
Does anybody knows why is this happening? And how can I solve this issue or if there is other way to extract the time (hh:mm) from this field.
Thanks
Then give this a shot
Time(Frac(Timestamp#(MyField, 'YYYY-MM-DD hh:mm:ss.fff')), 'hh:mm') as Time
Try this
Time(Frac(MyField), 'hh:mm') as Time
Then give this a shot
Time(Frac(Timestamp#(MyField, 'YYYY-MM-DD hh:mm:ss.fff')), 'hh:mm') as Time