Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Maybe
LOAD Timestamp(Timestamp#(YOURFIELD,'YYYYMMDDhhmm'),'MM/DD/YYYY hh:mm:ss TT') as TIMESTAMP,
...
Maybe
LOAD Timestamp(Timestamp#(YOURFIELD,'YYYYMMDDhhmm'),'MM/DD/YYYY hh:mm:ss TT') as TIMESTAMP,
...
Stefan,
How can do the same from DB?
Please advise.
May be this
TimeStamp(TimeStamp#(FieldName, 'YYYYMMDDhhmm'), 'MM/DD/YYYY hh:mm:ss TT')
or
TimeStamp(TimeStamp#(FieldName, 'YYYYMMDDhhmm'), 'MM/DD/YYYY hh:mm:ss')
How can do the same from DB?
Please advise.
Do it in the preceding load because I am not sure why DB you have and the syntax sometimes vary by databases
I guess you did mention that the database is AS400 DB... but I am not familar with the syntax on the db side
I'm doing it in Preceeding load. It worked.
Thanks brother!
This worked!
Thank you