Re: Globalization question

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_at_iinet.net.au

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.*

> 

> 




--
http://www.freelists.org/webpage/oracle-l