DATABASE/MySQL

현재 날짜 curdate() 잘르기 substring _ 내일

스티브 2019. 3. 27. 12:56

mysql> select substring(CONCAT((curdate() + INTERVAL 1 DAY)+0,"0000"),3,10);


+---------------------------------------------------------------+

| substring(CONCAT((curdate() + INTERVAL 1 DAY)+0,"0000"),3,10) |

+---------------------------------------------------------------+

| 1903280000                                                    |

+---------------------------------------------------------------+

1 row in set (0.00 sec)




# + INTERVAL 1 DAY 이용하자