Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 GetDate()

Author  Topic 

Mazdak
Yak Posting Veteran

63 Posts

Posted - 2003-02-27 : 03:28:50
From SQLServer Online books for GetDate():

Returns the current system date and time in the Microsoft® SQL Server™ standard internal format for datetime values.


How can I change the STANDARD INTERNAL FORMAT for datetime,or change the format of datetime for GetDate returning value.



macka
Posting Yak Master

162 Posts

Posted - 2003-02-27 : 03:45:47
Do a search in BOL for the CONVERT function.

macka.

--
There are only 10 types of people in the world - Those who understand binary, and those who don't.
Go to Top of Page
   

- Advertisement -