Hello,
You can DATE_FORMAT MySQL Command in your SQL Query. For example:
select DATE_FORMAT(yourdatetimefield,'%Y-%m-%d') from yourtable
--
Republic Of Turkey - Ministry of National Education
Education Technology Department Ankara / TURKEY
Web: http://www.haydartuna.net
""Mike Ryan"" <[
Got a question, I just noticed your signature, 'earn up to $10 per order
selling our PHP Scripts'. Are you paying us to help you out? =) Just
messing with ya.
Anyway, you'd probably want to use a 'DATE' field.
For checking the passing of a month, the easiest way would be to use the
getdate()
2 matches
Mail list logo