sql 查询 xx年x月x日之前 怎么写？

select * from XX
where (year<XX&&month<XX&&day<XX)

可以把年月日 转换成字符串 sql 就可以where time<'2007-09-16'

select * from XX
where xx < '2007-09-16'

where time<'2007-09-16'

to_date('xx-xx-xx','yy-mm-dd')转换格式