I want to convert a field from number to Timestamp.
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!
LOAD Timestamp(Timestamp#(YOURFIELD,'YYYYMMDDhhmm'),'MM/DD/YYYY hh:mm:ss TT') as TIMESTAMP,
How can do the same from DB?
May be this
TimeStamp(TimeStamp#(FieldName, 'YYYYMMDDhhmm'), 'MM/DD/YYYY hh:mm:ss TT')
TimeStamp(TimeStamp#(FieldName, 'YYYYMMDDhhmm'), 'MM/DD/YYYY hh:mm:ss')
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.
Retrieving data ...