How can I convert in db2 from unix epoch to normal timestamp?
I am trying to convert unix epoch time, to regular time stamp in db2.
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
momi_sabag:
i try
date('1970-01-01-00.00.00.
but the epoch in seconds is not the same type than date....
thats why is not working......
i try
date('1970-01-01-00.00.00.
but the epoch in seconds is not the same type than date....
thats why is not working......
epoch is the number of seconds since 01.01.1970 midinght so if you add that to the that date, it should provide you with the right answer
whats wrong with that solution?
ASKER
my mistake i didnt read that well,,, i read that + (epoch seconds) was my variable,
now i see than is + (epoch) seconds,,,,
my bad,, thanks for your answer.......
now i see than is + (epoch) seconds,,,,
my bad,, thanks for your answer.......
ASKER
Thas the correct anwer... thanks a lot...
DB2
IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.
6K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
'1970.01.01 00.00.00.000000' + epohch_column seconds
that will give you a db2 timestamp