[Sql Server] Formatação de datas

sql_server_date_format.sql

-- Exemplo de formatação de datas no Sql Server
SELECT 
  CONVERT(VARCHAR(12),GETDATE(),101) AS '101', --mm/dd/aaaa
  CONVERT(VARCHAR(12),GETDATE(),102) AS '102', --aa.mm.dd
  CONVERT(VARCHAR(12),GETDATE(),103) AS '103', --dd/mm/aaaa
  CONVERT(VARCHAR(12),GETDATE(),104) AS '104', --dd.mm.aa
  CONVERT(VARCHAR(12),GETDATE(),105) AS '105', --dd-mm-aa
  CONVERT(VARCHAR(12),GETDATE(),106) AS '106', --dd mês aa
  CONVERT(VARCHAR(12),GETDATE(),107) AS '107', --Mês dd, aa
  CONVERT(VARCHAR(12),GETDATE(),108) AS '108', --hh:mi:ss
  CONVERT(VARCHAR(12),GETDATE(),109) AS '109', --mês dd aaaa hh:mi:ss:mmmAM (ou PM)
  CONVERT(VARCHAR(12),GETDATE(),110) AS '110', --mm-dd-aa
  CONVERT(VARCHAR(12),GETDATE(),111) AS '111', --aa/mm/dd
  CONVERT(VARCHAR(12),GETDATE(),112) AS '112', --aammdd
  CONVERT(VARCHAR(12),GETDATE(),113) AS '113', --dd mês aaaa hh:mi:ss:mmm (24h)
  CONVERT(VARCHAR(12),GETDATE(),114) AS '114', --hh:mi:ss:mmm(24h)
  CONVERT(VARCHAR(12),GETDATE(),120) AS '120', --aaaa-mm-dd hh:mi:ss(24h)
  CONVERT(VARCHAR(12),GETDATE(),121) AS '121' --aaaa-mm-dd hh:mi:ss.mmm(24h)