DATE and SYSDATE in SQL server

[Dwij]

hie,

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

plz help......

[kelfro]

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.

[Modifier]

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.