Hi.
On Mon 2002-11-04 at 15:24:19 -0600, [EMAIL PROTECTED] wrote:
> More appropriately, use curdate()feature from within sql.
>
> select * where date= < curdate()-1;
Two points:
- How does this relate to the origianl question? He wanted to know how
to calculate a time interval.
- The above h
TED]
Subject: Re: mysql DATETIME substraction problem/?
Hello.
On Sun 2002-11-03 at 10:44:43 -0800, [EMAIL PROTECTED] wrote:
> Hello!
>
> I am working on an analysis that is very much dependent on calculating
> time differences in seconds. The most simple example:
>
> I have 3
Hello.
On Sun 2002-11-03 at 10:44:43 -0800, [EMAIL PROTECTED] wrote:
> Hello!
>
> I am working on an analysis that is very much dependent on calculating
> time differences in seconds. The most simple example:
>
> I have 3 variables: time_begin (DATETIME) time_end (DATETIME) and elapsed_
> sec
On Mon, 4 Nov 2002, gerald_clark wrote:
> You can't just subtract datetime fields. Check the date and time
functions
> in the manual.
Thanks,
I should know I run the risk of posting a RTFM/FAQ when I'm tired!
I got off track by misinterpreting "In MySQL Version 3.23, you can use +
and - inste
Jim,
Sunday, November 03, 2002, 8:44:43 PM, you wrote:
JH> I am working on an analysis that is very much dependent on calculating
JH> time differences in seconds. The most simple example:
JH> I have 3 variables: time_begin (DATETIME) time_end (DATETIME) and elapsed_
JH> seconds (INT). The dat
You can't just subtract datetime fields. Check the date and time functions
in the manual.
Jim Hogan wrote:
Hello!
I am working on an analysis that is very much dependent on calculating
time differences in seconds. The most simple example:
I have 3 variables: time_begin (DATETIME) time_end (D
