RE: [SPAM] - Re: How to get timezone in 9i - Bayesian Filter detectedspam

From: Jesse, Rich <Rich.Jesse_at_quadtechworld.com>
Date: Wed, 23 Feb 2005 08:45:53 -0600
Message-ID: <FB5D3CCFCECC2948B5DCF4CABDBE6697023511@QTEX1.qg.com>

STARDATE?!??!  Nooooooooooooooooooooo!

Sorry...flashback to Interbase (nee "Starbase") version 3 and a lost = day's work from our ERP system due to a corrupted DB caused by an = inadvertent client disconnect when a user's PC crashed. <shudder>

Rich

-----Original Message-----

From: oracle-l-bounce_at_freelists.org Behalf Of Mladen Gogala Sent: Tuesday, February 22, 2005 2:37 PM To: Christian.Antognini_at_trivadis.com
Cc: Ramesh FL; oracle-l

I don't see what is the problem? It works in 9.2.0.5:: Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.5.0 - Production

SQL> alter database set time_zone=3D'EST';

Database altered.

SQL> Are you sure that you're not trying to set TIMEZONE to STARDATE?

--=20

Mladen Gogala
Oracle DBA
Ext. 121
--

http://www.freelists.org/webpage/oracle-l Received on Wed Feb 23 2005 - 09:49:30 CST