26
26
# produce an error, not a NULL or anything
30
30
SELECT DAYOFMONTH("xxx");
34
34
SELECT DAYOFMONTH("0000-00-00"); # No 0000-00-00 dates!...
36
36
SELECT DAYOFMONTH("0000-01-01"); # No zero year parts
38
38
SELECT DAYOFMONTH("0001-00-01"); # No zero month parts
40
40
SELECT DAYOFMONTH("0001-01-00"); # No zero day parts
42
42
SELECT DAYOFMONTH("2000-02-30"); # No Feb 30th!
44
44
SELECT DAYOFMONTH("1900-02-29"); # Not a leap DAYOFMONTH since not divisible evenly by 400...
46
46
SELECT DAYOFMONTH('1976-15-15'); # No 15th month!
48
48
# A good date, which should output 1