Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
May be this:
=Timestamp(Timestamp#(KeepChar('Mon 08 03 14:26:00 2015 EDT', '0123456789:'), 'MMDDhh:mm:ssYYYY'))