Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

parsing timestamp

is there any article or blog on handling different type of timestamp string

i have a timestamp in below format . how can we parse it to timestamp

Mon 08 03 14:26:00 2015 EDT

2 Replies
Gysbert_Wassenaar

timestamp(timestamp#(keepchar('Mon 08 03 14:26:00 2015 EDT','0123456789'),'MMDDhhmmssYYYY'),'YYYY MMMM DD hh:mm:ss')

Change the last format string 'YYYY MMMM DD hh:mm:ss' to whatever you need.


talk is cheap, supply exceeds demand
sunny_talwar

May be this:

=Timestamp(Timestamp#(KeepChar('Mon 08 03 14:26:00 2015 EDT', '0123456789:'), 'MMDDhh:mm:ssYYYY'))