: Subtracting Dates
Well, I really do need the exact timespan in human-readable format. What I
did do was get the difference in seconds, then properly format that manually.
:/
Thanks anyway though.
On Friday 16 November 2001 07:24 am, Walter D. Funk wrote:
> Why don´t you try
> select T
it on their own.
>
> IMHO,
>
> Mark
>
> -Original Message-
> From: Ken Kinder [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 16, 2001 10:10 AM
> To: Walter D. Funk; [EMAIL PROTECTED]
> Subject: Re: Subtracting Dates
>
> Well, I really do need the
Well, I really do need the exact timespan in human-readable format. What I
did do was get the difference in seconds, then properly format that manually.
:/
Thanks anyway though.
On Friday 16 November 2001 07:24 am, Walter D. Funk wrote:
> Why don´t you try
> select TO_DAYS(end_date)-TO_DAYS(st
Why don´t you try
select TO_DAYS(end_date)-TO_DAYS(start_date) as duration : this will return
the difference in days
if you need mor accuracy i.e. difference in hours, you should word on a
TIMESTAMP 14 instead of date ; this data type holds up to seconds and is
mathematically easy to operate ...
i
