Count Days

Expand Post »

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

Similar Threads

convert seconds to minutes, hours, days, months, years, etc. in C
MSN Messenger unread mail count stuck in Windows Software
Days Out in C++
classes help in C++
critical count for quicksort?? in C

Lokesh.snghl

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

10 posts
since Jul 2008

Permalink

Jul 26th, 2008

Re: Count Days

hello

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

tesuji

Reputation Points: 158

Solved Threads: 98

Master Poster

Offline

720 posts
since Apr 2008

Permalink

Jul 26th, 2008

Re: Count Days

ah sorry, Easter() is my own udf, please replace it by for example yourBirthday.
krs, tesu

tesuji

Reputation Points: 158

Solved Threads: 98

Master Poster

Offline

720 posts
since Apr 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: Data Type mismatch!! :( Breaking my head on this for days!!!

Next Thread in MS SQL Forum Timeline: one to many relationships (with a twist)

DaniWeb Message

Cancel Changes

User Name
Password