Re: datepart + dateadd

Looks good to me, I don't see the error.

Maybe replacing nchar(2) with nvarchar(2) and removing the trailing « , 0 »
at the end of the convert functions.

Whats happens if you remove the Between clause and move the cast function
from the Where to the Select statement?

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC

"JEM" <Jenn@xxxxxxxxxxxxxxxxx> wrote in message
Thanks. I'm still not doing something right. Here is what i have:

SELECT dbo.tblChild.FName, dbo.tblChild.LName,
FROM dbo.tblChild
(CAST(CONVERT(nchar(2), DATEPART(month, dbo.tblChild.Birthday), 0) +
N'/' +
CONVERT(nchar(2), DATEPART(day, dbo.tblChild.Birthday), 0) + N'/' +
CONVERT(nchar(4), DATEPART(year, GETDATE()), 0) AS datetime)

Any ideas? I keep getting an error message that says something about
arithmetic overflow.


Relevant Pages

  • Error from DMAX in VBA
    ... I’m getting an error message “Run-time Error ‘2001’: ... This code works without errors when I don’t include the Where Clause ... OOrder is the field in the table tblOCode that holds the sequential numbers. ... SCode is unique in tblSCode. ...
  • RE: Strange error when querying FoxPro dbase
    ... I understand that you get the error message ... when using columns defined with AS inside the WHERE clause. ... This is a restriction related to SQL Command. ... INNER JOIN fldunit ON ...
  • Re: adoQuery - unspecified error on open
    ... unused ADOQuery component on my datamodule and connected it via the same ... > produces an error message vs the anticipated result ... > connection string ... > actually is you remove the parameter and the in clause, ...
  • Re: What is the problem with my SELECT statement ?
    ... The error message from JET displays only a limited number of characters, but my WHERE clause is longer and in this case the error is not visible in the message. ... I hope some time, some day I will find the time to write a real SQL designer, that will help the user pretty-print SQL statements and will ...
  • Re: adoQuery - unspecified error on open
    ... > produces an error message vs the anticipated result ... > actually is you remove the parameter and the in clause, ... > get the parameters yesterday but have since broken them as well. ... If I try to use a parameter, even in design it is not ...