I have a feeling that saving it as a numeric field would be quicker. Numeric fields are generally quicker than alphanumeric fields and the date field in mySQL has the format of yyyy-mm-dd, so it probably does some error checking/validation to see the format is correct and also it contains alphanumeric characters being -'s. The best way to probably find out is to select a large amount of records in both formats and see which is quicker.
hth -----Original Message----- From: Diana Castillo [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 1:02 PM To: [EMAIL PROTECTED] Subject: [PHP] date fiedl Does anyone know if there is any speed advantage to saving a date as a unix timestamp or a numeric field instead of a date field? (in Mysql) thanks, -- -- Diana Castillo Global Reservas, S.L. C/Granvia 22 dcdo 4-dcha 28013 Madrid-Spain Tel : 00-34-913604039 Fax : 00-34-915228673 email: [EMAIL PROTECTED] Web : http://www.hotelkey.com http://www.destinia.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -------------------------------------------------------------------- Disclaimer This e-mail transmission contains confidential information, which is the property of the sender. The information in this e-mail or attachments thereto is intended for the attention and use only of the addressee. Should you have received this e-mail in error, please delete and destroy it and any attachments thereto immediately. Under no circumstances will the Cape Technikon or the sender of this e-mail be liable to any party for any direct, indirect, special or other consequential damages for any use of this e-mail. For the detailed e-mail disclaimer please refer to http://www.ctech.ac.za/polic or call +27 (0)21 460 3911 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php