topic Re: Convert date time field to timestamp in App Development

Convert date time field to timestamp

Sagar082 — Tue, 28 Sep 2021 09:15:34 GMT

Hi folks,

Greeting for the day. I have a column which contains date and time in following format;

'24-AUG-21 12:00:00.4660000 AM'

It has string data type.

The desire format is;

24/08/2021 00:00:00

Should have data type timestamp.

Re: Convert date time field to timestamp

PrashantSangle — Tue, 28 Sep 2021 09:20:24 GMT

Check timestamp() and Timestamp#()

Re: Convert date time field to timestamp

PrashantSangle — Tue, 28 Sep 2021 09:22:50 GMT

=TimeStamp(Timestamp#('24-AUG-21 12:00:00.4660000 AM','DD-MMM-YY hh:mm:ss.ffff TT'))

Re: Convert date time field to timestamp

akshatagrawal — Tue, 28 Sep 2021 09:32:42 GMT

use this

TimeStamp(Timestamp#(ColumnName,'DD-MMM-YY hh:mm:ss.ffff TT'),'DD/MM/YYYY hh:mm:ss') as ColumnName

Re: Convert date time field to timestamp

Sagar082 — Wed, 29 Sep 2021 10:43:43 GMT

Hi,

Thank you for reply. But, it is not working.

Re: Convert date time field to timestamp

PrashantSangle — Wed, 29 Sep 2021 12:28:47 GMT

what do you mean by not working?? is it giving you any error? or giving you wrong output? can you share some screenshot of it..

Re: Convert date time field to timestamp

Sagar082 — Thu, 30 Sep 2021 09:45:27 GMT

It is not giving error. It is not computing value, output is "-"

Re: Convert date time field to timestamp

akshatagrawal — Thu, 30 Sep 2021 10:03:54 GMT

not sure, why it's not working for you. Please find below screenshot.

load * Inline
[
time1
24-AUG-21 12:00:00.4660000 AM
];

Re: Convert date time field to timestamp

PrashantSangle — Thu, 30 Sep 2021 11:33:24 GMT

where you are writing?? in text box or in script??

Re: Convert date time field to timestamp

Sagar082 — Mon, 04 Oct 2021 06:53:09 GMT

Hi, Prashant

I'm writing in script, as keen to have column to make different operations.

Re: Convert date time field to timestamp

PrashantSangle — Mon, 04 Oct 2021 06:54:16 GMT

is it possible for you to share an app? or share snip of script?

Re: Convert date time field to timestamp

Sagar082 — Mon, 04 Oct 2021 06:54:56 GMT

Hi, Akshat

I believe you are writing the formula in analysis window whereas I was trying it in load window.

Re: Convert date time field to timestamp

akshatagrawal — Mon, 04 Oct 2021 07:03:24 GMT

Hi Sagar,

I have tried it both the ways, data load editor as well as chart expression.

It's working fine. Please find attached screenshots.