Browse by Tags

Convert DateTime Format
17 May 09 03:08 PM | Ronen Chenn | 2 comment(s)

Hi , Recently I have encountered the need for extended date format such as quarter. So I found many tips over the web and concentrated them into to one post. For example 'MM/YYYY', and select Quarter from Getdate()... Hope this help! Ronen Date Format Standard SQL Statement Sample Output Mon DD YYYY 1 HH:MIAM (or PM) Default SELECT CONVERT(VARCHAR(20), GETDATE(), 100) Jan 1 2005 1:29PM 1 MM/DD/YY USA SELECT CONVERT(VARCHAR(8), GETDATE(), 1) AS [MM/DD/YY] 11/23/98 MM/DD/YYYY USA SELECT CONVERT...

תגים:SQL 2008, DEV, Date Format