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 > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]