Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sysdate on a different time zone

211722May 4 2006 — edited May 9 2006
I have an HP box siting in Melbourne (Australia East Standard time). This box will have several Oracle databases (db1,db2). The time in the box is local (AES).
I need to create a database (db99) in this box but I need the time to be Seoul (Korea).
So, if I select sysdate from db99 I get a different result than if I
select sysdate from db1.
How can I achieve this? Your help is most appreciated
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 6 2006
Added on May 4 2006
#general-database-discussions
3 comments
1,293 views