Datas SqlServer

Configuração de data no SqlServer:

select getdate() as DtHoraAtutal,
format(getdate(),'yyyy-MM-dd') as 'yyyy-MM-dd',
format(getdate(),'dd/MM/yyyy') as 'dd/MM/yyyy',
format(getdate(),'yyyy-MM') as 'yyyy-MM',
format(getdate(),'MM-yyyy') as 'MM-yyyy',
format(getdate(),'yyyyMM') as 'yyyyMM',
format(getdate(),'HH:mm:ss') as 'HH:mm:ss-24h',
format(getdate(),'hh:mm:ss') as 'HH:mm:ss-12h',
format(getdate(),'HH') as 'HH-24h',
format(getdate(),'hh') as 'HH-12h',
format(getdate(),'mm') as 'mm',
format(getdate(),'ss') as 'ss';

select convert(nvarchar(6), getdate(), 112) = '202503'

Comentários

Mais Visitados