create table dt (dt datetime);
--- OK
insert into dt values ( date_format('04/06/2002 13:48:38', '%d/%m/%Y
%H:%i:%s'));
--- Surprisingly it enters NULL
insert into dt values ( date_format('2002/04/06 13:48:38', '%Y/%d/%m
%H:%i:%s'));
--- Surprisingly (not really) it enters correct date
WHY is it so? I want the first insert to work properly. But it seems it is
not working. By simply moving the year part in first place makes the
statement to work properly. Why? Is it a MySQL bug. Please respond. I
already invested almost a day in finding it out.
Thanks
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
