Re: Date-format
| From: | Jacob Miller | Date: | Thu, 12 Sep 2002 08:18:43 +0000 |
| Subject: | Re: Date-format | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-116110@lists.php.net to get a copy of this message | ||
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