-
-
Notifications
You must be signed in to change notification settings - Fork 155
Open
Description
See here 👉 Line 108 of 10_Date_Time_Formats.sql
This query generates 'month day' eg.(June 15) value, not minutes without zero.
SELECT
'm',
FORMAT(GETDATE(), 'm'),
'Minutes without leading zero'
This is the correct way to make it works.
SELECT
'mm (custom)',
CAST(CAST(FORMAT(GETDATE(), 'mm') AS INT) AS VARCHAR),
'Minutes without leading zero'
Metadata
Metadata
Assignees
Labels
No labels