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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
