MS SQL

MS SQL RSS

Count Days

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Jul 2008

Posts: 10

Reputation: Lokesh.snghl is an unknown quantity at this point

Solved Threads: 0

Lokesh.snghl Lokesh.snghl is offline

Offline

Newbie Poster

Count Days

Jul 26th, 2008

hi all,

I want to calculate days b/w two different month
like as 7/15/2008 and 9/30/2008

this is silly question but i have problm to calculte ti .Its urgent in projec

•

Join Date: Apr 2008

Posts: 296

Reputation: tesuji is on a distinguished road

Solved Threads: 42

tesuji

Offline

Posting Whiz in Training

Re: Count Days

Jul 26th, 2008

hello

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
SELECT DATEDIFF(DAY, yourBirthday, getdate()) AS silly_days
SELECT DATEDIFF(DAY, yourBirthday, getdate()) AS silly_days

may work on mssqlserver.

krs,
tesu

Information is moving—you know, nightly news is one way, of course, but it's also moving through the blogosphere and through the Internets. I promise you I will listen to what has been said here, even though I wasn't here. Ann and I will carry out this equivocal message to the world. I'm the master of low expectations.