Developping for the translation industry RSS 2.0



 Monday, 19 January 2009

1072482_calendar

I wanted to write this down for some time now…

The Convert function in SQL Server provides a means to translate SQL Server’s default date format to just about any format. However, the convertion format isn’t intuitive at all. I wanted to have a quick reference for the future and help those who had trouble finding a list of all the possible convert options in T-SQL.

The syntax for the Convert function is as follows:

CONVERT ( data_type [ ( length ) ] , expression [ , style ] )
Available Date Formats:
  

Other Posts:

The T-SQL LoginProperty function in SQL Server 2005

How to restart a Windows service using C#

How to insert a file in an image column in SQL Server 2005

Monday, 19 January 2009 15:07:23 (Eastern Standard Time, UTC-05:00)  #    Comments [0] -
SQL
Comments are closed.

Navigation
Advertisement
About the author/Disclaimer

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

© Copyright 2018
Stanislas Biron
Sign In
Statistics
Total Posts: 135
This Year: 0
This Month: 0
This Week: 0
Comments: 1
All Content © 2018, Stanislas Biron