Retorno de Datas
Retorna
- Data Processada
- Primeiro dia do mês
- Primeiro dia da semana
- Inicio do dia
- Fim do dia
- Último dia da semana
- Último dia do mês
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
DECLARE @getdate DATETIME; SET @getdate = convert(char,GETDATE(),103) SELECT CAST('1) Data Processada' AS VARCHAR(50)), @getdate UNION SELECT CAST('2) Primeiro dia do mes' AS VARCHAR(50)), DATEADD(mm, DATEDIFF(mm, 0, @getdate), 0) UNION SELECT CAST('3) Primeiro dia da semana' AS VARCHAR(50)), DATEADD(wk, DATEDIFF(wk, 0, @getdate), 0) UNION SELECT CAST('4) Inicio do dia' AS VARCHAR(50)), DATEADD(dd, DATEDIFF(dd, 0, @getdate), 0) UNION SELECT CAST('5) Fim do dia' AS VARCHAR(50)), DATEADD(ms ,-3 ,DATEADD(dd, DATEDIFF(dd, 0, @getdate) + 1, 0)) UNION SELECT CAST('6) ultimo dia da semana' AS VARCHAR(50)), DATEADD(ms ,-3 ,DATEADD(wk, DATEDIFF(wk, 0, @getdate) + 1, 0)) UNION SELECT CAST('7) ultimo dia do mes' AS VARCHAR(50)), DATEADD(ms ,-3 ,DATEADD(mm, DATEDIFF(mm, 0, @getdate) + 1, 0)) |