Sql datum formatieren

SELECT convert(varchar, getdate(), 100) -- mon dd yyyy hh:mmAM

SELECT convert(varchar, getdate(), 101) -- mm/dd/yyyy – 10/02/2008                  

SELECT convert(varchar, getdate(), 102) -- yyyy.mm.dd – 2008.10.02           

SELECT convert(varchar, getdate(), 103) -- dd/mm/yyyy

SELECT convert(varchar, getdate(), 104) -- 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 (or PM)

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

Source: stackoverflow.com

Similar codes

7 votes204 views3 answers
Sql get last inserted row
SQL
0 vote194 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
2 votes219 views1 answer
Cast string to datetime mysql
SQL
0 vote214 views1 answer
Sql count null values in all columns
SQL
1 vote198 views1 answer
Sql server select rows by distinct column
SQL
16 votes203 views1 answer
Sql comment'
SQL
20 votes217 views5 answers
Sql show tables
SQL
40 votes240 views4 answers
PostgreSQL add column
SQL
0 vote197 views1 answer
Sql include rows with 0 values
SQL
4 votes186 views2 answers
Oracle set date format
SQL