Excel → T-SQL › TEXT
Excel TEXT to CONVERT / FORMAT
FORMAT is readable and slow in a filter. CONVERT style 23 is yyyy-mm-dd.
CONVERT(char(10), order_date, 23)
-- pretty, not for WHERE
FORMAT(order_date, 'yyyy-MM-dd')Style 103 is British dd/mm/yyyy. See /tools/datetime-matrix.
Canonical translation
CONVERT(char(10), order_date, 23)
-- pretty, not for WHERE
FORMAT(order_date, 'yyyy-MM-dd')Then write it on a ticket
Monday is free. A colleague asks, you type, we mark it.
Clock in free