Datediff for SQL

[wendas]

Hi,
I am a real newbie to SQL.. I have plans to go to school for it comming up but till then I am creating my stored procedures using access & then retyping them over into SQL.

I need to do a difference for dates.. Access successfully works with datediff('m',date1,date2)as MthDiff .. but when entered into SQL it errors with

"Error 1023", SQL server invalid parameter 1 specified for datepart.

I tried a few other combos like datediff(date1,date2,'m')
datediff(date1,date2)
datediff('ww',date1,date2)
with errors that made me sure the format was really wrong, or similar errors... Can anyone help?
Thanks
Wenda

 

[Andel]

Take out the quote on 'm'.

Select DATEDIFF (m, date1, date2)


Andel
andelbarroga@hotmail.com

http://andyb.8m.com

 

[wendas]

Thanks, but this did not seem to help..

It may be because I did not state I am a very old SQL server, (version 6.5)

But datediff(m,date1,date2) produced the error...

error 155: [sql server] 'm' is not a recognized datediff option.

 

[tlbroadbent]

Are you running this query in ISQL/w or from another program?

You might try spelling out "month" or using "mm" rather than just "m" for the datepart parameter. No quotes! Terry

http://members.home.net/tlbroadbent/index.htm

 

[wendas]

Thanks this was the answer
wenda