Re: date

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Rohtash Kapoor (rohtash_nospam_at_sqlmantra.com)
Date: 03/01/04

Next message: Arn0s: "Re: Stored procedure;1"
Previous message: Simon: "Re: Problem with INSERT INTO with string literal"
In reply to: Hrcko: "date"
Next in thread: Louis Davidson: "Re: date"
Reply: Louis Davidson: "Re: date"
Messages sorted by: [ date ] [ thread ]

Date: Mon, 1 Mar 2004 11:45:39 -0800

See DATEDIFF function in Book Online
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_5vxi.asp

---
Rohtash Kapoor
http://www.sqlmantra.com
"Hrcko" <hrcko@net4u.hr> wrote in message
news:c1vvn4$lfg$1@brown.net4u.hr...
> Is there a function, or can anyone tell me, how can I compare to dates?
> For Example: date is : 12.15.2001 and 08.01.2004. I would like a computer
to
> calculate the number of days, month and years between those two dates?
>
> Hrcko
>
>

Next message: Arn0s: "Re: Stored procedure;1"
Previous message: Simon: "Re: Problem with INSERT INTO with string literal"
In reply to: Hrcko: "date"
Next in thread: Louis Davidson: "Re: date"
Reply: Louis Davidson: "Re: date"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: date
... finer the grain, the more logical the result will seem. ... "Rohtash Kapoor" wrote in message ... > See DATEDIFF function in Book Online ... > "Hrcko" wrote in message ...
(microsoft.public.sqlserver.programming)
Re: date
... Using day as the first parameter to the datediff function? ... Tibor Karaszi, SQL Server MVP ... "Hrcko" wrote in message ...
(microsoft.public.sqlserver.programming)