|
|
![]() |
| Thread Tools | Search this Thread |
#1
| |||
| |||
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...... |
#2
| |||
| |||
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. |
#3
| |||
| |||
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. |
![]() |
|
Tags: date, sql server, sysdate |
Thread Tools | Search this Thread |
|
![]() | ||||
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 |