Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 31-03-2009
Member
 
Join Date: Feb 2009
Posts: 68
DATE and SYSDATE in SQL server

hie,

I wanna know about Oracle Date and Sysdate in SQL server.
Are they one and the same or something else?

plz help......
Reply With Quote
  #2  
Old 31-03-2009
Member
 
Join Date: Apr 2008
Posts: 2,001
Re: DATE and SYSDATE in SQL server

Dates are stored in the database as large numbers. The actual size of the data number is dependent on the operating system supporting the database. When a date is requested, it is returned in a human readable form.

When date values are compared in the WHERE clause, the format of the date must match the format that the database is using or the comparison will fail. Alternately, if you are using another format, then you must tell the database how your date is formatted.

The default format that the Oracle database uses is: DD-MM-YY.
Reply With Quote
  #3  
Old 31-03-2009
Member
 
Join Date: Jan 2008
Posts: 1,515
Re: DATE and SYSDATE in SQL server

SYSDATE is the function that helps you to get current operating system date.

The syntax to get the system date is -

SELECT SYSDATE FROM dual;

You will receive the reply in the following way -
(for e.g if Sysdate is 1st January 2009), then

SYSDATE
---------
01-JAN-09


DD-Mon-YY is the default format.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "DATE and SYSDATE in SQL server"
Thread Thread Starter Forum Replies Last Post
Baseline Column Date automatically updates Finish Date Adam 1980 Microsoft Project 3 18-05-2011 06:08 PM
How to set Password Expiration Date on Windows Server Robbin M Active Directory 1 03-07-2009 04:53 AM
Cast Sysdate and MYSQL fldrice Software Development 4 02-10-2008 06:56 PM
Windows 2000 Server query to disable date Saphire Window 2000 Help 2 09-11-2007 08:20 PM
Changing start date and creating formula for finish date stringse Microsoft Project 1 11-09-2006 01:13 PM


All times are GMT +5.5. The time now is 10:12 PM.