From http://www.mysql.com/doc/en/Using_DATE.html
<quote>
The format of a DATE value is 'YYYY-MM-DD'. According to ANSI SQL, no other
format is allowed. You should use this format in UPDATE expressions and in
the WHERE clause of SELECT statements. For example:
mysql> SELECT * FROM tbl_name WHERE date >= '1997-05-05';
</quote>
- Jacob
At 02:28 09/19/2002, Support @ Fourthrealm.com wrote:
>Reformatting before an inserting/updating is one option, but how would we
>change the mySQL database to accept the other format?
>
>Peter
>
>
>At 04:18 PM 9/12/2002 +0800, Jacob Miller wrote:
>>Why can't you just reformat it before inserting it into the db?
>>
>> $date = "31.12.2002";
>>
>> $parts = split("\.", $date);
>> echo $parts[2]."-".$parts[1]."-".$parts[0];
>>
>>- jacob
>>
>>At 16:13 09/12/2002, Tommi Virtanen wrote:
>>>Well, insert format in wrong, but in Finland enter format is dd.mm.yyyy,
>>>so I cannot use other insert format (it have to do other way).
>>>
>>>gustavus
>>>
>>> >It looks to me like the database is interpreting your date
>>> >incorrectly. Try changing the format you use to insert, yyyy-mm-dd
>>>
>>>
>>>
>>>--
>>>PHP General Mailing List (http://www.php.net/)
>>>To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>>--
>>PHP General Mailing List (http://www.php.net/)
>>To unsubscribe, visit: http://www.php.net/unsub.php
>
>- - - - - - - - - - - - - - - - - - - - -
>Fourth Realm Solutions
>[EMAIL PROTECTED]
>http://www.fourthrealm.com
>Tel: 519-739-1652
>- - - - - - - - - - - - - - - - - - - - -
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
