Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> fixed_Date in Oracle 7.3

fixed_Date in Oracle 7.3

From: Faisal <faisal_qasimpk_at_yahoo.com>
Date: 28 Feb 2003 00:24:46 -0800
Message-ID: <d55ce0a6.0302280024.e2b0031@posting.google.com> 





Dear All,



We have changed fixed_Date using 'alter system' command. It is
reflecting fine in 'sysdate'. But when a database package accessed
'sysdate', it returns initial value of sysdate. New fixed date value
is not reflected.



Why does SqlPlus returns a different 'sysdate' and package returns a
different 'sysdate'.



I will be grateful for any help.




Regards
Received on Fri Feb 28 2003 - 02:24:46 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US