opam: update
[sqlgg.git] / test / datetime.sql
blob957c1bb5c970c518947d2ef8c384a1d539085546
1 SELECT TIMESTAMPDIFF(MONTH,'2003-02-01','2003-05-01');
2 SELECT TIMESTAMPDIFF(YEAR,'2002-05-01',@x);
3 SELECT TIMESTAMPDIFF(MINUTE,'2003-02-01','2003-05-01 12:05:55');
4 SELECT TIMESTAMPDIFF(MONTH, '2019-11-12', CURRENT_TIMESTAMP())
5 -- not allowed
6 -- SELECT TIMESTAMPDIFF(@MONTH,'2003-02-01','2003-05-01');