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
    Posts
    19

    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
    Location
    Portland, OR
    Posts
    8,387
    Is it running on Windows? What happens if you change the system date?
    Phil Weber
    http://www.philweber.com

    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
    Posts
    19
    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
    Posts
    19
    sorry, i already found the problem,
    i need to change the SYSDATE of the SERVER.

Similar Threads

  1. setting up asp.net 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
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

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