Message-Id: <10666.120671@fatcity.com> From: MTPConsulting@aol.com Date: Tue, 31 Oct 2000 10:03:31 EST Subject: 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@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@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@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.