Re: Date-format

It looks to me like the database is interpreting your date incorrectly. Try changing the format you use to insert, yyyy-mm-dd - jacob At 15:11 09/12/2002, Tommi Virtanen wrote:

Hi! I have web-form, which has field (10 chars), there I enter date (format dd.mm.yyyy). Then data saves to database (date-field type is date). So everything works, but not fine. When I enter date in format ex. 31.12.2002 and save form, then I'll check what are in db (there are 2031-12-20). Is there any chance to correct this problem. I have (in clause which insert to db): GetSQLValueString($HTTP_POST_VARS['date'], "date") gustavus -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php