Date Arithmetic with Leap Year?!
Leap years BREAK date math! February 28 + 1 day = February 29 in leap years, March 1 in non-leap years. This edge case will cause bugs!
#sql #sqltricks #datearithmetic #leapyear #dateadd #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #datefunctions #advancedsql
DATE_FORMAT with Edge Cases?!
DATE_FORMAT has HUNDREDS of format codes! %j is day of year, %W is weekday name. This formatting language will confuse you!
#sql #sqltricks #dateformat #formatcodes #dateformatting #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #datefunctions #advancedsql
DATEADD(month, 1, '2024-01-31') Returns WHAT?!
Adding 1 month to Jan 31 creates something impossible! February doesn't have 31 days. SQL handles this in a weird way! Watch!
#sql #sqltricks #database #sqltutorial #datearithmetic #edgecases #sqlquiz #codingchallenge #sqlshorts #sqlbugs #datefunctions #sqlwtf
Date Functions With NULL Return NULL?!
DATEADD and DATEDIFF with NULL return NULL instead of error! Date arithmetic with NULL breaks all date logic! Watch now!
#sql #sqltricks #database #sqltutorial #datefunctions #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #dateoperations #sqlwtf
CAST('2024-02-30' AS DATE) Returns WHAT?!
SQL handles invalid dates in weird ways! February 30 doesn't exist but SQL might return NULL, error, or wrap to next month! Watch!
#sql #sqltricks #database #sqltutorial #invaliddate #datecasting #sqlquiz #codingchallenge #sqlshorts #sqlbugs #datefunctions #sqlwtf
Fun with JavaScript Date:
>> new Date(3456, 4, 5).toISOString()
"3456-05-04T22:00:00.000Z"
>> new Date(23456, 4, 5).toISOString()
"+023456-05-04T22:00:00.000Z"
Who asked for the '+' sign and the zero padding beyond four digit years? Not that I live long enough to see the whole Internet crumble by this year-10000 bug, but, come on!
PrecisionSQL
Harald