DB2 Epoch function

PKPChuck · #1 (**permalink**) 11-26-07, 11:01

DB2 8.2
AIX 5.2

I've got a trigger which insert a current timestamp in DB2 Timestamp format but I want to have a trigger which inserts current EPOCH time. I haven't been able to find a db2 function for it, so was looking for the least hack way to do it.

Thanks,

Charlie

sathyaram_s · #2 (**permalink**) 11-26-07, 11:39

DAYS or JULIAN_DATE functions.

n_i · #3 (**permalink**) 11-26-07, 11:39

See if this helps:

Code:

db2 values bigint(days(current date) - days('1970-01-01'))*bigint(86400) 
+ midnight_seconds(current_timestamp - current_timezone)

Internet Services

Web Development

Digital Marketing

Consumer Tech