Transact-SQL Date Format Conversions

: Joel Lipman; Transact-SQL; 19 November 2010; Hits: 9607

Source: http://www.kodyaz.com/articles/sql-format-date-format-datetime-t-sql-convert-function.aspx

Credit where Credit is Due:

Feel free to copy, redistribute and share this information. All that we ask is that you attribute credit and possibly even a link back to this website as it really helps in our search engine rankings.

Disclaimer: Please note that the information provided on this website is intended for informational purposes only and does not represent a warranty. The opinions expressed are those of the author only. We recommend testing any solutions in a development environment before implementing them in production. The articles are based on our good faith efforts and were current at the time of writing, reflecting our practical experience in a commercial setting.

Thank you for visiting and, as always, we hope this website was of some use to you!

Kind Regards,

Joel Lipman
www.joellipman.com

Convert to Proper Case in T-SQL (25124) Joel Lipman (Transact-SQL)
What? So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a...
T-SQL example of Case-Sensitive Soundex (8126) Joel Lipman (Transact-SQL)
What? This article is for demonstrating how to use a SOUNDEX in a select and then listing all the variations based on...
T-SQL DateTimestamps (7358) Joel Lipman (Transact-SQL)
My setup Windows XP SP3 MS SQL Server Management Studio 2008 SQL Server 2008 R2 Regional Setting: London BST (British...
Split a row into multiple rows based on a column value (28393) Joel Lipman (Transact-SQL)
Applies to Transact-SQL (T-SQL) What? This is a quick article on how to split a single row into multipe rows based on...
T-SQL functions to convert Strings to Tables (6293) Joel Lipman (Transact-SQL)
Applies to: Microsoft SQL Server 2008 R2 Microsoft SQL Server 2012 What? These were in a solution and I thought I'd note...
T-SQL Record Separator (9805) Joel Lipman (Transact-SQL)
I have googled, binged and asked but to no avail. Some self-proclaimed IT experts in forums said "why would you want...
Transact-SQL Date Format Conversions (9607) Joel Lipman (Transact-SQL)