[ADSM-L] SQL help

ADSM-L

[Top] [All Lists]

[ADSM-L] SQL help

2009-10-21 15:28:11

Subject:	[ADSM-L] SQL help
From:	Fred Johanson <Fred AT UCHICAGO DOT EDU>
To:	ADSM-L AT VM.MARIST DOT EDU
Date:	Wed, 21 Oct 2009 14:25:22 -0500

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?

[More with this subject...]

<Prev in Thread]	Current Thread	[Next in Thread>
[ADSM-L] SQL help, Fred Johanson <= Re: [ADSM-L] SQL help, Remco Post Re: [ADSM-L] SQL help, Fred Johanson

Previous by Date:	Re: [ADSM-L] VSS Hotfix list for Windows 2008, Cory Heikel
Next by Date:	Re: [ADSM-L] SQL help, Remco Post
Previous by Thread:	[ADSM-L] VM/TSM, Timothy Hughes
Next by Thread:	Re: [ADSM-L] SQL help, Remco Post
Indexes:	[Date] [Thread] [Top] [All Lists]