: 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
> - Original Message -
> From: "Ken Kinder" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, November 15, 2001 8:32 PM
> Subject: Subtracting Dates
>
> > The date addition and subtraction functions in mysql don't seem to quiet
...
i hope it helps
- Original Message -
From: "Ken Kinder" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 15, 2001 8:32 PM
Subject: Subtracting Dates
> The date addition and subtraction functions in mysql don't seem to quiet
do
> this.
The date addition and subtraction functions in mysql don't seem to quiet do
this. I was wondering if anyone know a way I could do this in the query:
Say you have two fields, start_time, and end_time, representing the start and
end of a period of time. Both are datetime datatypes. What I want is