RE: datetime/timestamps/4.1.12

[DePhillips, Michael P]

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