Convert DateTime Format

יום ראשון, מאי 17, 2009

  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 1HH: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 11/23/98 MM/DD/YYYY USA ...
תגיות: , ,
5 תגובות