Re: Globalization question
- From: Nuno Souto <dbvision@xxxxxxxxxxxx>
- To: painterman@xxxxxxxxx
- Date: Thu, 11 Dec 2008 22:31:57 +1100
I don't understand the "statement will fail" bit.
But your select sysdate from dual should not change:
10:00 is 10:00, no matter what time zone you're in.
It's the time in other timezones than yours that changes.
If your timezone is Europe/London and your system
says it's 10:00, then it's 10:00 in Europe/London, period.
If you then change the database timezone to America/New_York,
it'll still be 10:00 according to the system, but now in NY.
What happens if you set database to Europe/London and
you query with timezone of America/New_York, then
you change the timezone to the latter and you query
AGAIN for NY?
--
Cheers
Nuno Souto
in rainy Sydney, Australia
dbvision@xxxxxxxxxxxx
David Pintor wrote,on my timestamp of 11/12/2008 9:54 PM:
/Answer:/
/The statement will fail./
When I run this on my database, the ALTER DATABASE... statement does not
fail (see below). However, I have tried putting London, Athens or
whatever city and when I query sysdate from dual I always get my local
time. So I guess the last one is the correct one? or did I miss anything
here?
*SQL> CREATE TABLE ORDERS (ORDER_DATE TIMESTAMP(0) WITH TIME ZONE);
Table created.
SQL> INSERT INTO ORDERS VALUES('18-AUG-00 10:26:44 PM America/New_York');
1 row created.
SQL> INSERT INTO ORDERS VALUES('23-AUG-02 12:46:34 PM America/New_York');
1 row created.
SQL> commit;
Commit complete.
SQL> ALTER DATABASE SET TIME_ZONE='Europe/London';
Database altered.*
--
//www.freelists.org/webpage/oracle-l
Other related posts:
