From: Soheil Shaghaghi <[EMAIL PROTECTED]>
> SELECT AnnouncementID,Title,DateShown FROM ANNOUNCEMENT WHERE
> DateShown=NOW() ORDER BY DateShown DESC
> ...I only want to look at the month, and the day
SELECT AnnouncementID,Title,DateShown
FROM ANNOUNCEMENT
WHERE substring(DateShown,6,5) = substring(NOW(),6,5)
ORDER BY DateShown DESC
Try these for an explination:
select substring('2001-02-03 04:05:06', 6,5) as mon_day,
substring('2001-02-03 04:05:06', 6,2) as mon,
substring('2001-02-03 04:05:06', 9,2) as day;
select substring(now(), 6,5) as mon_day,
substring(now(), 6,2) as mon,
substring(now(), 9,2) as day;
---
Rodney Broom
Programmer: Desert.Net
sql
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
