In this post we will discuss about various date formats in sql server 2008. Also you can check my previous posts on:
- Implement delete functionality in Gridview in Asp.Net
- Upload multiple files in Asp.Net file upload control
- Asp.Net page life cycle events
By default if GETDATE() function returns like this, 2013-11-24 14:37:59.463.
By if you want you can format GETDATE () result like below:
Various formats are
Select CONVERT(VarChar, GETDATE(), 120) As NewDateFormat
Select CONVERT(VarChar, GETDATE(), 121) As NewDateFormat
Select CONVERT(VarChar, GETDATE(), 126) As NewDateFormat
Select CONVERT(VarChar, GETDATE(), 127) As NewDateFormat
Select CONVERT(VarChar, GETDATE(), 130) As NewDateFormat
Select CONVERT(VarChar, GETDATE(), 131) As NewDateFormat
If you run above queries, the result will appear like below:
- Implement delete functionality in Gridview in Asp.Net
- Upload multiple files in Asp.Net file upload control
- Asp.Net page life cycle events
By default if GETDATE() function returns like this, 2013-11-24 14:37:59.463.
By if you want you can format GETDATE () result like below:
Various formats are
Select CONVERT(VarChar, GETDATE(), 120) As NewDateFormat
Select CONVERT(VarChar, GETDATE(), 121) As NewDateFormat
Select CONVERT(VarChar, GETDATE(), 126) As NewDateFormat
Select CONVERT(VarChar, GETDATE(), 127) As NewDateFormat
Select CONVERT(VarChar, GETDATE(), 130) As NewDateFormat
Select CONVERT(VarChar, GETDATE(), 131) As NewDateFormat
If you run above queries, the result will appear like below: