[IQUG] convert UNIX EPOCH into a date/time inside IQ
Tarlo.Sandhu at bmo.com
Tue Jun 4 13:44:40 MST 2019
You can use dateadd function as below:
select dateadd(second, 1354320000, '1970-01-01') ;
This example will give you 2012-12-01 00:00:00
From: iqug-bounces at iqug.org [mailto:iqug-bounces at iqug.org] On Behalf Of Ray Naugle
Sent: June-04-19 4:31 PM
To: iqug at iqug.org
Subject: [IQUG] convert UNIX EPOCH into a date/time inside IQ
I am getting a date in the form of a UNIX EPOCH (seconds from Jan 1, 1970 00:00) and need to convert to a date/time inside IQ. Is there an easy way to do that?
[my help pages I typically use aren't working at present - quicker to ask here]
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the IQUG