幾天後有誰生日
- Eddy
-
Topic Author
- Offline
- 管理員
-
Less
More
2006-05-15 16:07 #2438
來自 Eddy
fecnac is the date of birth.
知之者不如好之者，好之者不如樂之者
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.