add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
(No column name)
Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64)
Oct 8 2022 05:58:25
Copyright (C) 2022 Microsoft Corporation
Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)
SortKey Trunc date part Result Value
1 (none) Right now 2023-06-17 03:30:04.4097820
2 YEAR Beginning of this year 2023-01-01 00:00:00.0000000
3 MONTH Beginning of this month 2023-06-01 00:00:00.0000000
4 DAY Zero hour today 2023-06-17 00:00:00.0000000
5 HOUR Beginning of this hour 2023-06-17 03:00:00.0000000
6 MINUTE Beginning of this minute 2023-06-17 03:30:00.0000000
7 SECOND Beginning of this second 2023-06-17 03:30:04.0000000