DATETIME vs CHAR for "timestamp"
- Date: Fri, 14 Apr 2017 12:11:09 -0700
- From: SSC_perl <perl@xxxxxxxxxxxxxxxx>
- Subject: 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?
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql