Hello,

Hi,
I was looking for a DB2 functions which was equivlent of GetUTCdate() from SQL SERVER.

I want to create a table with a timestamp column that has a default value of UTC timestamp.

I tried:
DbServerTime timestamp not null with DEFAULT current timestamp - current timezone

but this is incorrect.

Thank you.

Considering your server timestamp in EST, you can try something like the following:

>db2 "create table test_timestamp (
Employee_Id smallint,
TS_EST timestamp with default current timestamp,
TS_UTC timestamp generated always as (TS_EST + 5 hours) )"

>db2 "select employee_id, TS_UTC from test_timestamp"

EMPLOYEE_ID TS_UTC
----------- ------- ----------------------
3311 2011-02-16-02.15.18.532000

(deleted due to incorrect information)

Thanks for the suggestion; i will use it. Surprised that I cannot do it with a single column.

Adding 5 hours only works when Daylight Savings Time is not in effect.

agreed. that is why i have tried with current timestamp - current timezone; but that syntax will not work at the DDL level.

That's correct, + 5 hours willn't consider DST.

What you can do is to add a field in the table with datatype timestamp (e.g. TS_UTC), and then write an AFTER INSERT Trigger on the same table, which will update the TS_UTC field for every insert with values derived from "current timestamp - current timezone".