Re: datetime field - still a newbie
| From: | Richard Lynch | Date: | Fri, 26 Jul 2002 16:46:02 +0000 |
| Subject: | Re: datetime field - still a newbie | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-109809@lists.php.net to get a copy of this message | ||
>I have a datetime field in one of my mysql tables...when displaying some of
>my records I want to display the date in the aforementioned datetime field,
>but if the date is today I want to display "today" instead. If the date is
>yesterday I want it to display that .... so I how do I compare the date in
>my record to todays date? Thanks
There are functions in MySQL like now() and to_days() that you can use to
determine how many days are between two dates.
http://mysql.com/
--
Like Music? http://l-i-e.com/artists.htm
I'm looking for a PRO QUALITY two-input sound card supported by Linux (any
major distro). Need to record live events (mixed already) to stereo
CD-quality. Soundcard Recommendations?
Software to handle the recording? Don't need fancy mixer stuff. Zero (0)
post-production time. Just raw PCM/WAV/AIFF 16+ bit, 44.1KHz, Stereo
audio-to-disk.