On 21 okt 2009, at 21:25, Fred Johanson wrote:

Management want to count the number of nodes added in the last 2
months.  I think this is what they want, but it returns 0

select count(node_name) from nodes where (cast((date(reg_time)-
current_date)days as decimal) <= 60)

select count(*) from nodes where reg_time >current_timestamp - 60 days

does that sound better to you?

What did I do wrong?

--
Met vriendelijke groeten,

Remco Post
r.post AT plcs DOT nl
+31 6 248 21 622