RE: date calculation for Australia

Try this:

(assuming that the system is set to GMT) select sysdate+(10/24)
from dual;

If your system is not at GMT you can run the appropriate conversion for your local time to GMT and then add 10hrs (10/24 in Oracle time) for Sydney which is at GMT+10.

HTH Rodd Holman
Enterprise Data Systems Engineer
LodgeNet Entertainment Corporation
rodney.holman_at_lodgenet.com
Comments made are my own opinions and views. They do not represent views, policies, or procedures of LodgeNet Entertainment Corporation

> -----Original Message-----
> From: Nancy McCormick [SMTP:nmccormick_at_sbti.com]
> Sent: Monday, October 30, 2000 4:12 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: date calculation for Australia
>
> Try the built-in Oracle function new_time.
> Nancy
>
> -----Original Message-----
> pajerowski
> Sent: Monday, October 30, 2000 4:47 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hello,
> Is it possible to convert GMT to Australian time
> (SYDNEY) using date functions.
>
> Thanks
> sonia P.
>
> __________________________________________________
Received on Mon Oct 30 2000 - 16:42:40 CST