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
