sybperl-l Archive

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