Re: date

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/03/04

Next message: Roji. P. Thomas: "Re: Truncate table being referenced by a foriegn key"
Previous message: Roji. P. Thomas: "Re: Truncate table being referenced by a foriegn key"
In reply to: Hrcko: "RE: date"
Messages sorted by: [ date ] [ thread ]

Date: Wed, 3 Mar 2004 12:39:48 +0100

Using day as the first parameter to the datediff function? The function is
documented in Books Online.

-- 
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Hrcko" <anonymous@discussions.microsoft.com> wrote in message
news:4FE3D929-6549-47DB-A1CD-2899C2832C0C@microsoft.com...
> I manage to get years and months, but i can't calculate the days!
> HOw ?

Next message: Roji. P. Thomas: "Re: Truncate table being referenced by a foriegn key"
Previous message: Roji. P. Thomas: "Re: Truncate table being referenced by a foriegn key"
In reply to: Hrcko: "RE: date"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Calculate the total time in minute between 2 dates
... I tried use DateDiff function, the result is not accurate, because the date ... > Lookup the DATEDIFF function in Books Online. ... > David Portas ... > SQL Server MVP ...
(microsoft.public.sqlserver.programming)
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
... See DATEDIFF function in Book Online ... Rohtash Kapoor ... "Hrcko" wrote in message ...
(microsoft.public.sqlserver.programming)