changing time settings in DB2 UDB

mixxalot · #1 (**permalink**) 12-10-03, 13:54

We have our new DB2 UDB 7.2 FP10a on AIX 5.2L (both database and OS are 32 bit) reporting time in CST instead of PST. How can I change this time setting in the database so that it reports time in Pacific Standard Time?

Thanks

n_i · #2 (**permalink**) 12-10-03, 16:18

Quote:

Originally posted by mixxalot
We have our new DB2 UDB 7.2 FP10a on AIX 5.2L (both database and OS are 32 bit) reporting time in CST instead of PST. How can I change this time setting in the database so that it reports time in Pacific Standard Time?

I think it will show time in whatever timezone is set on the server by the OS.

Internet Services

Web Development

Digital Marketing

Consumer Tech