Timestamps VS Date/Time Types
| From: | Jordan Elver | Date: | Fri, 06 Apr 2001 10:25:10 +0000 |
| Subject: | Timestamps VS Date/Time Types | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-8306@lists.php.net to get a copy of this message | ||
Hi,
I'm getting a bit confused about what date types to use in my applications
and MySQL db.
I have used timestamps and I know how to format them, convert them and
compare them etc but now I am about to build a calender type script and I'm
not sure what to use. For example, if I insert a load of calender
appointments into the table, how would I sleect all the events in a certain
month (if the dates were timestamps) ?
What are the advantages of timestamps over other date//time fileds and vice
versa?
Thanks for any help,
Cheers,
Jord