Alter session set nls_date_format='yyyymmddhh24:mi:ss' ???
It probably doesn't like the dd being concatenated against the hh24 section
without a space either ....
-----Original Message-----
From: Jeff Thies [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 3:02 PM
To: [EMAIL PROTECTED]
Subject: sql error
I'm drawing a blank on an error I'm getting inserting a "date"
(2001070112:00:00) into a varchar field.
Cannot execute: You have an error in your SQL syntax near ':00:00)' at
line 1
my $sql=q{INSERT INTO some_table(the_date) values(?)};
my $sth=$dbh->prepare($sql);
$sth->execute($the_date) || die "Cannot execute: $DBI::errstr\n";
What could be wrong?
Jeff