[ADSM-L] SQL help
2009-10-21 15:28:11
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)
What did I do wrong?
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [ADSM-L] SQL help,
Fred Johanson <=
|
|
|