The QUARTER() function succeeds in these instances where it should have failed - Invalid dates: See /home/aarti/repos/temporal-data/tests/suite/temporal/t/quarter.test
#--error 1686 #SELECT QUARTER("0000-01-01"); #--error 1686 #SELECT QUARTER("0001-00-01"); #--error 1686 #SELECT QUARTER("0001-01-00"); #--error 1686 #SELECT QUARTER("2000-02-30");
SELECT QUARTER('07-31-2009'); QUARTER('07-31-2009') NULL Warnings: Warning 1292 Incorrect datetime value: '07-31-2009'
SELECT QUARTER('1976-15-15'); QUARTER('1976-15-15') NULL
SELECT QUARTER('0000-00-00'); QUARTER('0000-00-00') 0
SELECT QUARTER('2008-12-00'); QUARTER('2008-12-00') 4
The QUARTER() function succeeds in these instances where it should have failed - Invalid dates: repos/temporal- data/tests/ suite/temporal/ t/quarter. test
See /home/aarti/
#--error 1686 "0000-01- 01"); "0001-00- 01"); "0001-01- 00"); "2000-02- 30");
#SELECT QUARTER(
#--error 1686
#SELECT QUARTER(
#--error 1686
#SELECT QUARTER(
#--error 1686
#SELECT QUARTER(
SELECT QUARTER( '07-31- 2009'); '07-31- 2009')
QUARTER(
NULL
Warnings:
Warning 1292 Incorrect datetime value: '07-31-2009'
SELECT QUARTER( '1976-15- 15'); '1976-15- 15')
QUARTER(
NULL
SELECT QUARTER( '0000-00- 00'); '0000-00- 00')
QUARTER(
0
SELECT QUARTER( '2008-12- 00'); '2008-12- 00')
QUARTER(
4