Page 1 of 1

select help needed

Posted: Tue Feb 10, 2004 11:39 am
by pelegk2
i have this code :

Code: Select all

select * from order_color where   month(from_unixtime(order_date)) = '2'  and year(from_unixtime(order_date))='2004'
an what i am missing i want to add to the select question todays day of the month!
how do i do that?
htnaks in advance
peleg

Posted: Wed Feb 11, 2004 3:55 am
by twigletmac