Web lists-archives.com

DATETIME vs CHAR for "timestamp"




	I have creation date/time fields in my script that are formatted as YYYY|MM|DD|hh|mm|ss.  Short of changing the script, should I set the field type in MySQL to DATETIME, or would it be better in terms of speed and efficiency to set it as char(19)?  Or would it not make a difference?

Thanks,
Frank
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql