PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Louis Proyect <lnp3 at columbia dot edu>
Subject: Conversion syntax error
Date: Jun 8 1999 7:21PM

This works in ISQL:

select new_date = (convert(smalldatetime, '19970630'))

But this: 

$dbh->dbcmd("select new_date = (convert(smalldatetime, '19970630'))");
$dbh->dbsqlexec;

Returns the message:

102 1 15 Incorrect syntax near 'new_date'.

What might the problem be?

Louis Proyect
Columbia University