Check out DATE_SUB() and DATE_ADD() functions. Those are the one to do
the trick.
sherzodR
On Mon, 26 Nov 2001, Julio Faerman wrote:
>Hi !
>I have a table with 2 coluns with time values , for example, colum START
>("2001-11-20 23:34:03" , for example) and STOP ("2001-11-21 08:34:03" , for
>e
Hi !
I have a table with 2 coluns with time values , for example, colum START
("2001-11-20 23:34:03" , for example) and STOP ("2001-11-21 08:34:03" , for
example).
Given a interval of time, say 8 AM to 8 PM, i need my query to return the
total time between START and STOP outside this period.
Is t
