Can't update the datetime files using UPDATE table SET statment.
Posted on 2006-11-28
I have and Access table on which I'm trying to update a columns which is in date/time format. I am using PERL. I tried multiple different options but it still does not want to work. I'm using ODBC to access it.
The PERL code I'm using:
my $query = "UPDATE tblLibraries SET DateStamp = '$newDateStamp' WHERE LibraryID = '$libraryID'";
$newDateStamp is in the format "YYYY-MM-DD HH:MM:SS"
$libraryID is just an integer that point to the KEY column.
I'm new in using database. A week a ago I didn't even know how to build tables. This might be simple but I can't find a solution to it. I tried functions like DATEFORMAT, to_date but they don't work. These factions are probably specific to some other SQL server.
Can one of you help me?