Convert UNIX Epoch to Timestamp

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
eli.nawas_AUS
Premium Member
Premium Member
Posts: 39
Joined: Tue Apr 15, 2014 9:14 am

Convert UNIX Epoch to Timestamp

Post by eli.nawas_AUS »

Is there a function available to convert unix epoch number (eg 1381816859) to timestamp (eg 2013-10-15 06:00:59)?
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

Yes:

Code: Select all

TimestampFromTimet()
Conversely:

Code: Select all

TimetFromTimestamp()
Choose a job you love, and you will never have to work a day in your life. - Confucius
Post Reply