DECLARE @StartData datetime; SET @StartData = CURRENT_TIMESTAMP; SELECT CAST(CONVERT(char(4), @StartData, 112) + '1231' AS datetime) AS FineAnno; /* Output: FineAnno ----------------------- 2009-12-31 00:00:00.000 (1 row(s) affected) */
DECLARE @startData smalldatetime SET @startData = GETDATE() -- ottengo il 31/12 SELECT CAST(CONVERT(char(4), @StartData, 112) + '1231' AS smalldatetime) AS NewData
SELECT CAST(CONVERT(char(4), @StartData, 112) + '1231' AS datetime) AS FineAnno;