datediff

[DanHD]

hello,

i need to count the difference between two dates. In the database they use the format

2010-03-22 13:53:38.000
and
2010-09-10 21:30:14.717

I've tried difference functions, but each time I receive an error 'Incorrect syntax near '13'.

How can I solve this?

Dan

 

[markros]

Can you show the code?

datediff(day,@Date1, @Date2) should have worked assuming dates are real datetime values.

PluralSight Learning Library

 

[DanHD]

hoi markros

for eample:

select datediff(day,2010-03-19 09:50:09.000, 2010-05-27 10:46:31.000)

results in:

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '09'.


Dan

 

[markros]

The dates in SQL Server are enclosed in single quotes, so
select datediff(day,'2010-03-19 09:50:09.000', '2010-05-27 10:46:31.000')

will be correct.

PluralSight Learning Library

 

[DanHD]

thanks markros

it works

Dan