[freetds] ODBC: syntax error? select datediff(d,{d 2003-04-1 5},{d 2003-04-1 5})
Garrett Goebel
garrett at scriptpro.com
Tue Apr 15 17:30:50 EDT 2003
Lowden, James K wrote:
>
> > From: Garrett Goebel
> >
> > Any ideas on why
> >
> > select datediff(d,{d 2003-04-15},{d 2003-04-15})
> >
> > Would result in a syntax error?
>
> Peering closely at the sent buffer:
>
> > Sending packet @ 2003-04-15 09:04:14.689699
> ...
> > |...3.... select d|
> ...
> > |atediff( d,'2003-|
> ...
> > |04-15',' 2003-04-|
> ...
> > |14'|
>
> What happened to the closing parenthesis?
>
> $dbh->prepare("select datediff(d,{d '2003-04-15'},{d '2003-04-14'}");
> should be
> $dbh->prepare("select datediff(d,{d '2003-04-15'},{d '2003-04-14'})");
oops! thanks for the catch.
> P.S. I'll follow up on the archive searching tonight.
thanks!
More information about the FreeTDS
mailing list