1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| USE tempdb;
GO
CREATE TABLE temps
(
date DATETIME
);
GO
INSERT temps VALUES (DATEADD(m, -1 * RAND() * 100, GETDATE()));
GO 200000
SET STATISTICS TIME ON;
SELECT DAY(DATEADD (m, 1, DATEADD (d, 1 - DAY(date), date)) - 1)
FROM temps
SELECT DAY(DATEADD(month, 1, CONVERT(DateTime,CONVERT(varchar(7),date,120) + '-01',120))-1)
FROM temps
-- SQL Server Execution Times:
-- CPU time = 235 ms, elapsed time = 851 ms.
-- SQL Server Execution Times:
-- CPU time = 359 ms, elapsed time = 982 m |
Partager