maria db today sql (오늘 날짜 출력 쿼리)

 

today (오늘)

 

select DATE_FORMAT(CURDATE(), '%Y-%m-%d') as 'today'
----------------------------------------------------
"today"
"2019-09-29"

 

 

yserterday (오늘)

 

select DATE_FORMAT(CURDATE() - 1, '%Y-%m-%d') as 'today'
--------------------------------------------------------
"today"
"2019-09-29"

 

 

after 9 hour (9시간후)

 

select DATE_FORMAT(NOW()+INTERVAL 9 hour, '%Y-%m-%d %H')
--------------------------------------------------------
"DATE_FORMAT(NOW()+INTERVAL 9 hour, '%Y-%m-%d %H')"
"2019-09-30 20"

 

 

before 9 hour (9시간전)

 

"DATE_FORMAT(NOW()-INTERVAL 9 hour, '%Y-%m-%d %H')"
"2019-09-30 02"
---------------------------------------------------
"DATE_FORMAT(NOW()-INTERVAL 9 hour, '%Y-%m-%d %H')"
"2019-09-30 02"