Date difference(datetime,mysql)

[abstraktmedia]

Hi there...I have two dates in mysql(4.1.10) datetime field...

time_start
2005-03-09 00:45:00

and
time_end
2005-03-09 02:00:00

And I'm trying to get the difference betwean them(which is obviously 1:15)
with

UNIX_TIMESTAMP(time_end) - UNIX_TIMESTAMP(time_start)

which gives me just "4500" !?

I also tried

FROM_UNIXTIME(UNIX_TIMESTAMP(time_end) - UNIX_TIMESTAMP(time_start), '%h:%i:%s')

which gives me "02:15:00" and that's not correct(it should be 01:15:00)

Can anyone help with this....

[abstraktmedia]

Problem solved...I used TIMEDIFF()...

TIMEDIFF() was added in MySQL 4.1.1.

[stereofrog]

And I'm trying to get the difference betwean them(which is obviously 1:15)
with

UNIX_TIMESTAMP(time_end) - UNIX_TIMESTAMP(time_start)

which gives me just "4500" !?

FYI, 4500 seconds is 75 minutes and 75 minutes is one hour 15 minutes, what is exactly what you expected.

Off Topic:


Isn't this a shame that I have to explain this on the programmer's forum?

[r937]

for those not on 4.1.1 yet, you can still get nice looking results like this --

select sec_to_time( unix_timestamp(time_end) 
                  - unix_timestamp(time_start) ) 
           as time_diff