topic Timestamp function not working timestamp# in App Development

Timestamp function not working timestamp#

rajpreeths — Wed, 04 Aug 2021 12:34:30 GMT

Dear All,

I am fetching a column which has timestamp value in the format of YYYY-MM-DD hh:mm:ss.(fff) and am trying to use this column to convert as timestamp TIMESTAMP(TIMESTAMP#(data_loaded_date,'YYYY-MM-DD hh:mm:ss.(fff)')

Unfortunately timestamp# works fine but when I add timestamp on top of timestamp# it returns null value.Any one has faced this kind of issue ? Or is it a bug ? Could anyone help me on this

I need to fetch latest modified records for which I need to convert data_loaded_date as a timestamp and use max of it. Please advice

Re: Timestamp function not working timestamp#

Taoufiq_Zarra — Wed, 04 Aug 2021 12:47:58 GMT

can you share a sample data ?

Re: Timestamp function not working timestamp#

Or — Wed, 04 Aug 2021 13:02:28 GMT

Are you sure the Timestamp#() is working correctly? If it is, you should be able to view the underlying field as both text (the timestamp format) and as a number (the underlying date/time, e.g. 42321.124), so formatting it as a number should let you see if it's actually getting the correct result as you expect.

Re: Timestamp function not working timestamp#

rajpreeths — Wed, 04 Aug 2021 13:17:45 GMT

Guys, Yes timestamp# returns correct value. Sample value is as below

2021-07-06 13:12:34.576940000

Created dimesion is

TIMESTAMP(TIMESTAMP#(data_loaded_date,'YYYY-MM-DD hh:mm:ss.(fff)') ) as formatedts

I am using timestamp on top of timestamp# because I need to load records based on latest timestamp . To find latest timestamp I am using max fucntion like max(formatedts)

When I use timestamp# only the values are as expected but still max fucntion returns null value

Please advice

Re: Timestamp function not working timestamp#

Or — Thu, 05 Aug 2021 10:22:51 GMT

I attempted to use TimeStamp#() on your sample value and it does not work on my end. I am not getting a timestamp value, just the original value as text. However, when using your sample, I am able to use the value directly as a timestamp - TIMESTAMP(data_loaded_date,'YYYY-MM-DD hh:mm:ss.(fff)') works correctly.