Tuesday, April 10, 2012

MySQL Time bomb at Midnight

I've been working around this issue for ages. MySQL won't store 00:00:00 as midnight. Apparently it's illegal to store that in MySQL. I never really thought about it until I "had" to store midnight in a time field.
The solution is really simple. Just add this to your database connection string in your datasource in the ColdFusion Administrator: useFastDateParsing=false

No comments: