Re: Date-format

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 pbechard@fourthrealm.com 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