Wednesday, November 15, 2017

when sysdate is not as system date

Dear my audience
there is a problem of difference of sysdate than system date or that sysdate show wrong date and here after search and test and try i find the solution are

SQL> alter system set fixed_date = none
  2  /
 
System altered.
 
SQL> select sysdate
  2    from dual
  3  /
 
SYSDATE
-------------------
15-11-2017 10:53:40
 
 
best regards
Yasser

No comments:

Post a Comment