[Scorpion_134]

I have recently started learning more and more about SQL, but this statement has me confused. If you could tell me what this means that would be great. Thanks!!

(DateDiff(dd, ISNULL(x.CDate, '1/1/1900'), y.DDate) > 5)

[modi123_1]

Just break it down.


(DateDiff '-- you want to read about datediff here.
(dd, '-- from that link dd is day.. so are getting the number of days between two dates.
ISNULL('-- you should read about isnull here.
x.CDate, '-- some column name
'1/1/1900') '-- if that column is null then use this date.
, y.DDate) '-- find the number of days between x.CDate (or 01/01/1900 if x.Cdate is null) to y.Ddate
> 5)

'-- if that number of days between said dates is greater than five return true or else false.

[Scorpion_134]

modi123_1, on 11 October 2012 - 07:10 AM, said:

Just break it down.


(DateDiff '-- you want to read about datediff here.
(dd, '-- from that link dd is day.. so are getting the number of days between two dates.
ISNULL('-- you should read about isnull here.
x.CDate, '-- some column name
'1/1/1900') '-- if that column is null then use this date.
, y.DDate) '-- find the number of days between x.CDate (or 01/01/1900 if x.Cdate is null) to y.Ddate
> 5)

'-- if that number of days between said dates is greater than five return true or else false.

Thanks for your Reply. I am somewhat new to SQL so I was just making sure I was reading it correctly.

[modi123_1]

Hmmm.. well next time I'll have to make you tell me what you think it says first. Also I just noticed this is mysql not mssql... the function explanation is the same but you may get a bit more mileage out of hitting up the mysql search bar.