Mega Code Archive

 

Categories / MSSQL Tutorial / Data Convert Functions

 

SELECT Default Date

4>  SELECT 'Default Date: ' + CONVERT(VarChar(50), GETDATE(), 100) 5> GO ---------------------------------------------------------------- Default Date: Aug  7 2008  9:19PM (1 rows affected)