CONVERT date styles make date displays explicit. Keep the typed value for date logic and agree the output format with the receiving interface.
Fiscal Years That Do Not Start in January
Compute fiscal years and quarters from an April start, build indexed date boundaries, and store a fiscal calendar for repeatable reports.
SQL SERVER – Information Related to DATETIME and DATETIME2
A reader comment explains the precision issue between DATETIME and DATETIME2: values lose precision when converted between types. Here is the workaround.
CURRENT_DATE, || and Other Small T-SQL Changes in SQL Server 2025
Use CURRENT_DATE, string concatenation, optional SUBSTRING length and bigint DATEADD in SQL Server 2025 with clear examples and checks.
Leap Years in T-SQL: February 29 and Date Math
Handle leap years in T-SQL with date functions, test February boundaries, and choose a clear anniversary rule for February 29 births.
DATE_BUCKET: Align 15-Minute Windows With an Origin
DATE_BUCKET uses an origin to align reporting windows. Keep width, unit and origin explicit while checking timestamps around each boundary.
datetime2 Precision: Rounding Can Cross Midnight
datetime2 precision changes can round into the next second or date. Compare typed seven-digit values with millisecond and whole-second conversions.