Best to use int field type and store the difference between the unix
timestamp start time and the unix timestamp end time (both seconds since the
epoch) which would be the number of seconds it took to complete the task.
This number can then be manipulated with math to provide elapsed times in
h
Why would you not simply use a 'datetime' field type? This gets
you exactly what you are looking for unless I am misreading what you are
doing here...
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Bomgardne
: Re: [PHP-DB] time field query problems.
Steve,
> For some reason the below statement is not working. Can anyone tell me
why?
>
> Select EDIT_LOCK from ordmaster where EDIT_LOCK + INTERVAL 10 MINUTE <
now()
> AND ORDER_NO = '5' AND EDIT_LOCK > 0;
>
> -EDIT_
Steve,
> For some reason the below statement is not working. Can anyone tell me
why?
>
> Select EDIT_LOCK from ordmaster where EDIT_LOCK + INTERVAL 10 MINUTE <
now()
> AND ORDER_NO = '5' AND EDIT_LOCK > 0;
>
> -EDIT_LOCK is a MySQL (ver 3.23.49-max) time field, allows nulls, default
is
> NULL.
>
, July 29, 2002 3:13 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] time field query problems.
On Tuesday 30 July 2002 02:41, Steve Bradwell wrote:
> Sorry to repost but I typed in the wrong sql statement in my previous
post.
>
> For some reason the below statement is not working. Can anyon
On Tuesday 30 July 2002 02:41, Steve Bradwell wrote:
> Sorry to repost but I typed in the wrong sql statement in my previous post.
>
> For some reason the below statement is not working. Can anyone tell me why?
>
> Select EDIT_LOCK from ordmaster where EDIT_LOCK + INTERVAL 10 MINUTE <
> now() AND