MySQL関数メモ

 
MySQL関数メモ
 
日付関数

1 SELECT

2     t1.xcjyrq,

3     t1.*

4 FROM

5     view_sbxx t1

6 WHERE

7     t1.syzt = 1

8 AND YEAR (t1.xcjyrq) > YEAR (NOW()) - 1

9 AND YEAR (t1.xcjyrq) < YEAR (NOW()) + 1;

 

SELECT

    t1.xcjyrq,

    t1.*

FROM

    view_sbxx t1

WHERE

    t1.syzt = 1

AND YEAR (t1.xcjyrq) > YEAR (NOW()) - 1

AND YEAR (t1.xcjyrq) < YEAR (NOW()) + 1;

 
文字列関数
 
数学関数