DateTime problem
Having a problem writing to the DB... DateTime as GMT choking
Hey folks,
I've got everything installed and set up fine. It actually looks really good!
But anytime I try to add a user, add a section... anything that requires a date... I get a mySQL error saying: #1292 - Incorrect datetime value: '2006-07-22 23:15:25 GMT' for column 'create_date' at row 1
Now... if I take my sql statement, go into mySQL and input that statement, minus "GMT" it goes in just fine.
Did I miss something in my set up of mySQL? Is there a way to remove the GMT out of what's being sent to the database?
I'd be grateful for any help!
--stw
I've got everything installed and set up fine. It actually looks really good!
But anytime I try to add a user, add a section... anything that requires a date... I get a mySQL error saying: #1292 - Incorrect datetime value: '2006-07-22 23:15:25 GMT' for column 'create_date' at row 1
Now... if I take my sql statement, go into mySQL and input that statement, minus "GMT" it goes in just fine.
Did I miss something in my set up of mySQL? Is there a way to remove the GMT out of what's being sent to the database?
I'd be grateful for any help!
--stw