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: [email protected]
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
