Hello.
According to the output of mysqld --help --verbose these variables (date_format and datetime_format) don't work yet, they're exists for future purposes. [EMAIL PROTECTED] wrote: > Mike, > Have you tried creating a new table with a field for some sort of date? > Try adding some data and see if the new date time format you specified in > the my.cnf file. See if that works. > -sam > >> Hello, >> >> Nevermind - duh -datetime is not timestamp (oneday I fullfill my promise >> to myself and not work on Sundays when my 'duh' level is a bit higher). >> >> So....from what I gather, the backward compatibility comes in the form of >> adding a +0 (string to int). >> >> This is most inconvenient and annoying. >> >> Any plans on rectifying this, or has anyone found a workaround, or are we >> left to go SIOH (hint OH stands for "our hat") :-} >> >> Later... >> Michael >> >> -----Original Message----- >> From: DePhillips, Michael P >> Sent: Sun 7/17/2005 11:05 AM >> To: mysql@lists.mysql.com >> Cc: >> Subject: datetime/timestamps/4.1.12 >> >> >> >> Hello, >> >> I just upgraded to 4.1.12 from 4.0.22 and my timestamps changed formats >> to >> %Y-%m-%d %H:%i:%s >> >> So I added the following lime to my my.cnf file >> >> datetime_format=%Y%m%d%H%i%s >> >> Which is the format I prefer, I restart the server and my time stamps >> still appear as >> %Y-%m-%d %H:%i:%s >> >> The 'show variables' command now confirms that the format is what I >> defined in the my.cnf but the output of the query does not change... >> >> >> What am I missing? >> >> Thanks, >> Michael >> >> > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]