Timestamps VS Date/Time Types

From: 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

« previous php.db (#8306) next »