Re: date calculation for Australia

But, be aware that none of these methods account for Summer Time/Daylight Savings changes. You will need to have logic to adjust the time (or vary the offset) when the switch occurs. And since that date can vary by year -- for example it was way early in Australia this year because of the Olympics -- you will need to store the dates in a table somewhere.

The best source I've found for time zone information including DST transitions is www.timeanddate.com.

Marc Perkowitz
MTP Systems Consulting

In a message dated 10/30/00 4:53:31 PM Central Standard Time, rodney.holman_at_lodgenet.com writes:

> 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.
Received on Tue Oct 31 2000 - 09:03:31 CST