How write a stredprocedure to get the date from 1st jan to tilldate

The SQL function DATEDIFF() can give you the time between two dates.  it can give you seconds, minutes, hours, days(maybe more).

Hi,

SELECT * FROM WHERE > '01012008'

You may want to check the syntax of the query.

Thanks -- Vj

http://dotnetvj.blogspot.com      

In SQL Server -

GETDATE will get your the current date.

You can use the DATEPART function to extract the year and concatenate a '1/1/' to the year to create the first day of the year.

Not sure if that was what you were looking for...