Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Database in UTC - need to view in CST

Ratzie
Super Advisor

Database in UTC - need to view in CST

Our database (vendor built) must be in UTC.
How do I view the UTC dates in CST?

Would this be a procedure that I call?
If so how?

Or can I alter session... with out effecting data if i do an insert.
1 REPLY
Frank de Vries
Respected Contributor

Re: Database in UTC - need to view in CST

Oracle actually recommends to use UTC
and use regional settings in your application.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/ch4datetime.htm

Look before you leap