topic Re: Convert number to Timestamp in QlikView

Convert number to Timestamp

markgraham123 — Fri, 13 Oct 2017 14:26:01 GMT

Hi all,

I want to convert a field from number to Timestamp.

Eg:

201710112044 - 10/11/2017 08:44:00 PM (or) 10/11/2017 20:44:00

I'm fetching it from AS400 DB.

How do i do that in DB/QlikView?

Any help is highly appreciated!

swuehl — Fri, 13 Oct 2017 14:28:40 GMT

Maybe

LOAD Timestamp(Timestamp#(YOURFIELD,'YYYYMMDDhhmm'),'MM/DD/YYYY hh:mm:ss TT') as TIMESTAMP,

...

markgraham123 — Fri, 13 Oct 2017 14:29:06 GMT

Stefan,

How can do the same from DB?

Please advise.

sunny_talwar — Fri, 13 Oct 2017 14:29:17 GMT

May be this

TimeStamp(TimeStamp#(FieldName, 'YYYYMMDDhhmm'), 'MM/DD/YYYY hh:mm:ss TT')

TimeStamp(TimeStamp#(FieldName, 'YYYYMMDDhhmm'), 'MM/DD/YYYY hh:mm:ss')

markgraham123 — Fri, 13 Oct 2017 14:30:56 GMT

How can do the same from DB?

Please advise.

sunny_talwar — Fri, 13 Oct 2017 14:32:59 GMT

Do it in the preceding load because I am not sure why DB you have and the syntax sometimes vary by databases

sunny_talwar — Fri, 13 Oct 2017 14:33:50 GMT

I guess you did mention that the database is AS400 DB... but I am not familar with the syntax on the db side

markgraham123 — Fri, 13 Oct 2017 14:34:44 GMT

I'm doing it in Preceeding load. It worked.

Thanks brother!

markgraham123 — Fri, 13 Oct 2017 14:35:04 GMT

This worked!

Thank you