[IQUG] convert UNIX EPOCH into a date/time inside IQ

Sandhu, Tarlo 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

Regards,

Tarlo Sandhu




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]

Thanks!
Ray Naugle
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20190604/4ecaa4be/attachment.html>


More information about the IQUG mailing list