subject:"SEC_TO_TIME not working\?"

Re: SEC_TO_TIME not working?

2003-09-16 Thread Paul DuBois

At 2:55 PM -0700 9/16/03, Grant Cooper wrote: SELECT DailyLog.TimeOut, DailyLog.TimeIn, SEC_TO_TIME(UNIX_TIMESTAMP(DailyLog.TimeOut) - UNIX_TIMESTAMP(DailyLog.TimeIn)) as test FROM DailyLog keeps on giving me a result as a date. Not time in years, days, hours, min. For example 9/9/2007 12:51:26 P

SEC_TO_TIME not working?

2003-09-16 Thread Grant Cooper

SELECT DailyLog.TimeOut, DailyLog.TimeIn, SEC_TO_TIME(UNIX_TIMESTAMP(DailyLog.TimeOut) - UNIX_TIMESTAMP(DailyLog.TimeIn)) as test FROM DailyLog keeps on giving me a result as a date. Not time in years, days, hours, min. For example 9/9/2007 12:51:26 PM - 9/9/2007 12:51:26 PM gives me 12:00 PM. I