|
|
How to format datetime in SQL query
Sun, 05/22/2011 - 10:13
In my table I have a date field that is stored in mm/dd/yyyy. In SQL select query in query analyzer I want it to be displayed in form of dd.mm.yyyy. Is there any date format function for this kind of operation?
Similar entries
- conversion of date to DD-MMM-YYYY format in asp.net
- Data Source Name(DSN) Connection to database in ASP using DSN
- Where is viewstate information stored and in which format
- delete records from one table which are in other table
- How to get current date and time and display it in particular format
- Uttar Pradesh Class 12th Intermediate Exam Time Table 2012
- www.ctet.nic.in CBSE CTET 2012 Online Application form Exam Date Time Table Registartion Admit Card
- The type Date is ambiguous jsp error
- How to add or subtract days in a date using JSP
- Rajasthan Public Service Commision Revised Exam Schedule IInd Grade Teacher Recruitment 2011
Use convert method for different date time formats in SQL server.for dd.mm.yyyy
SELECT convert(varchar, getdate(), 104) – dd.mm.yyyy
This will show current date in dd.mm.yyyy format
More dateformats example
SELECT convert(varchar, getdate(), 100) – mon dd yyyy hh:mmAM (or PM)
SELECT convert(varchar, getdate(), 101) – mm/dd/yyyy
SELECT convert(varchar, getdate(), 102) – yyyy.mm.dd –
SELECT convert(varchar, getdate(), 103) – dd/mm/yyyy
SELECT convert(varchar, getdate(), 105) – dd-mm-yyyy
SELECT convert(varchar, getdate(), 106) – dd mon yyyy
SELECT convert(varchar, getdate(), 107) – mon dd, yyyy
SELECT convert(varchar, getdate(), 108) – hh:mm:ss
SELECT convert(varchar, getdate(), 109) – mon dd yyyy hh:mm:ss:mmmAM
SELECT convert(varchar, getdate(), 110) – mm-dd-yyyy
SELECT convert(varchar, getdate(), 111) – yyyy/mm/dd
SELECT convert(varchar, getdate(), 112) – yyyymmdd
SELECT convert(varchar, getdate(), 113) – dd mon yyyy hh:mm:ss:mmm
SELECT convert(varchar, getdate(), 114) – hh:mm:ss:mmm(24h)
SELECT convert(varchar, getdate(), 120) – yyyy-mm-dd hh:mm:ss(24h)
SELECT convert(varchar, getdate(), 121) – yyyy-mm-dd hh:mm:ss.mmm
SELECT convert(varchar, getdate(), 126) – yyyy-mm-ddThh:mm:ss.mmm