#datefunctions — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #datefunctions, aggregated by home.social.
-
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