insert date problem
| From: | simon dot pospisil at fastsearch dot com | Date: | Fri, 31 Aug 2001 10:18:04 +0000 |
| Subject: | insert date problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-12024@lists.php.net to get a copy of this message | ||
I get the following error when I try the statement below. Through
elimination I know it is the dates that are causing the problem. I have
set the date format to this: alter session set NLS_DATE_FORMAT =
'YYYY-MM-DD';
$sql_season: insert into season (id, code, start_date, end_date) values
(16, 'all', '2001-04-06', '2001-09-20')
Warning: OCIStmtExecute: ORA-01861: literal does not match format string
in ... on line 44
Can anyone help?
Cheers
Simon.