Demo

討論

保持飢餓,保持愚笨 (Stay hungry, stay foolish)。 史蒂夫·賈伯斯

公告

本網站已取消討論區的討論方式,如果您有問題請至LINE群行動條碼圖片網址,或Facebook社團

幾天後有誰生日

More
2006-05-15 16:07 #2438 來自 Eddy
Eddy created the topic: 幾天後有誰生日
select * from YourTable
where
(unix_timestamp(date_format(fecnac,"2003-%m-%d 00:00:00")))
between (unix_timestamp(date_format(curdate(),"2003-%m-%d 00:00:00")))
and (unix_timestamp(date_format((curdate()+interval 7 day),"2003-%m-%d 00:00:00")))

fecnac is the date of birth.

知之者不如好之者,好之者不如樂之者

Please 登入 to join the conversation.