Excel → T-SQL › TODAY
Excel TODAY to CAST(GETDATE() AS date)
GETDATE() is now, with a clock. TODAY is the calendar day. Cast, or you miss nothing after midnight only by luck.
CAST(GETDATE() AS date)WHERE order_date = CAST(GETDATE() AS date) fails on datetime. Use a half-open range.
Canonical translation
CAST(GETDATE() AS date)Then write it on a ticket
Monday is free. A colleague asks, you type, we mark it.
Clock in free