Home » RDBMS Server » Server Administration » Determining time zone
Determining time zone [message #372392] Thu, 08 February 2001 09:22 Go to next message
Dan Murphy
Messages: 1
Registered: February 2001
Junior Member
Does anyone know how to determine the time zone that the box Oracle is running on is set to from SQL? I need this for the NEW_TIME function. The answer ultimately needs to be something like "EST" or"CST" and then "EDT" or "CDT" when daylight savings time comes.

Thanks.

Report message to a moderator

Re: Determining time zone [message #372399 is a reply to message #372392] Thu, 08 February 2001 15:19 Go to previous message
Deborah Welch
Messages: 7
Registered: September 2000
Junior Member
If you know how to find it on the host operating system, you can do the HOST command from within SQL*Plus and get it that way.

Report message to a moderator

Previous Topic: Dyamic Column Building using SQL Query
Next Topic: Re: Function based indexes
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 01 13:19:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.