Help datetime - Mailing list pgsql-sql

From Tubagus Nizomi
Subject Help datetime
Date
Msg-id 01060814364602.08639@ocemz
Whole thread Raw
List pgsql-sql
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


pgsql-sql by date:

Previous
From: "Postgresql"
Date:
Subject: need help please on triggers..
Next
From: "ivan"
Date:
Subject: update from another table