DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: current date in oracle

  1. #1
    Join Date
    Dec 2006

    current date in oracle

    hi guys.
    i have a question regarding the current date in oracle
    is it possible for me to alter/change the current date
    in oracle. I need to do this to test the application
    that i have developed.
    If it is possible, how can i change it?

    thnx in advance.

  2. #2
    Join Date
    Nov 2003
    Portland, OR
    Is it running on Windows? What happens if you change the system date?
    Phil Weber

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

  3. #3
    Join Date
    Dec 2006
    yes it is running in windows.
    in my SQL, i used the SYSDATE in the computation.
    however even if i changed the System date of my
    computer it seems that the date used in the computation is still
    the current date.

    when i execute the statement,

    select current_date from dual;

    i still get the current date, so i am thinking that maybe
    i am getting the system date retrieved from oracle.

    is there any way for me to change this?
    Last edited by ysabelle; 01-03-2007 at 09:52 PM.

  4. #4
    Join Date
    Dec 2006
    sorry, i already found the problem,
    i need to change the SYSDATE of the SERVER.

Similar Threads

  1. setting up server
    By kylemcna in forum ASP.NET
    Replies: 5
    Last Post: 04-13-2007, 02:23 AM
  2. Replies: 3
    Last Post: 11-14-2001, 08:33 PM
  3. ADO DBTimeStamp and Oracle Julian date
    By Mikolaj Kobylinski in forum VB Classic
    Replies: 1
    Last Post: 04-18-2001, 09:25 AM
  4. date parameter in Oracle Stored Procedure
    By Naveen in forum VB Classic
    Replies: 1
    Last Post: 06-13-2000, 06:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center