Re: Sysdate Value

From: HansF <News.Hans_at_telus.net>
Date: Sun, 22 Jan 2006 22:19:13 GMT
Message-Id: <pan.2006.01.22.22.19.12.592977@telus.net>

On Sun, 22 Jan 2006 10:50:38 -0800, Pria wrote:

> From where
> Oracle brings in sysdate if the init parameter fixed_date do not have
> any value set against it.

If you look at the documentation (Oracle Database Reference manual), you will note that there is not default value for fixed sysdate. You must specify that value or it will complain.

For the sake of amusement, here is a bit of noodling in that area on my XE system, using the fact that the FIXED_DATE parameter is dynamic:

fuzzy:~> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Beta on Sun Jan 22 15:12:29 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta

SQL> alter system set fixed_date
  2 ;

*
ERROR at line 2:
ORA-00927: missing equal sign

SQL> alter system set fixed_date='01-jan-4004';

System altered.

SQL> alter system set fixed_date=none;

System altered.

SQL> !time

SQL> !date
Sun Jan 22 15:14:38 MST 2006

SQL> alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS';

Session altered.

SQL> select sysdate from dual;

SYSDATE

---

2006-01-22 15:15:27

SQL> !date
Sun Jan 22 15:15:37 MST 2006

SQL> alter system set fixed_date='4004-01-01 01:01:01';

System altered.

SQL> select sysdate from dual;

SYSDATE

---

4004-01-01 01:01:01

SQL> select sysdate from dual;

SYSDATE

---

4004-01-01 01:01:01

SQL> alter system set fixed_date=none;

System altered.

SQL> !date
Sun Jan 22 15:16:39 MST 2006

SQL> select sysdate from dual;

SYSDATE

---

2006-01-22 15:16:43

SQL>

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***

Received on Sun Jan 22 2006 - 16:19:13 CST