Help datetime

From: Tubagus Nizomi <nizomi(at)dnet(dot)net(dot)id>
To: pgsql-sql(at)postgresql(dot)org
Subject: Help datetime
Date: 2001-06-08 07:36:46
Message-ID: 01060814364602.08639@ocemz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message Luis Sousa 2001-06-08 08:54:41 Hidden Select
Previous Message David BOURIAUD 2001-06-08 07:02:12 Re: Re: About i8n