[MYSQL] Confused about DATETIME compare/subtraction

2003-08-16 Thread PAUL MENARD
Hello All, I'm having trouble understanding the MySQL docs on how to subtract two DATETIME values. I have two tables that have a DATETIME column. In my SELECT I am doing a JOIN to bring in both sets of rows. What I want is to subtract the DATETIME values to determine the number of seconds

Re: [MYSQL] Confused about DATETIME compare/subtraction

2003-08-16 Thread Rajesh Kumar
PAUL MENARD wrote: Hello All, I'm having trouble understanding the MySQL docs on how to subtract two DATETIME values. I have two tables that have a DATETIME column. In my SELECT I am doing a JOIN to bring in both sets of rows. What I want is to subtract the DATETIME values to determine the