Thread: Help datetime

Help datetime

From
Tubagus Nizomi
Date:
i have problem in datetime

my_table (start_date datetime,stop_date datetime);
insert into my_table values 
('Sun May 13 16:19:27 2001 JAVT','Sun May 13 14:06:13 2001 JAVT')

select stop_date-start_date from my_table
the result is "@ 2 hours 13 mins 14 secs"
but i want result in minutes(integer) not interval

have idea ??

plz help me

thanks
Nizomi