Date: 02/10/06 (MySQL Communtiy)    Keywords: mysql, software, sql, web, google

Hi...

I have googled, dev.mysql.com'ed, RTFM and stuff, and I'm a little frustrated, I hope someone here knows the definitive answer.

We developed our web-based software on version 3.23.41 where the timestamp format is YYYYMMDDHHMMSS, I'm sure you know the drill.

Now, we're migrating to a new server, with 4.1.12 and the timstamp default format is %Y-%m-%d %H:%i:%s

The big question: Can I change this version of MySQL (I do have root access) to use the old type of timestamp format?

If so, How? Or, can you point me to a resource that explains it?

Again, I have tried google, dev.mysql.com, etc. I apologize if this is a dumb question, but so far all sources point to it just being the format and nothing I can do. I kinda don't believe that, as it sounds like an inflexibility that would cause other developers to run into problems upgrading....unless of course, I am doing it all wrong!

Any help is appreciated.

Source: http://community.livejournal.com/mysql/85482.html