From: | "Pablo Prieto" <pablo(dot)prieto(at)dulcesol(dot)es> |
---|---|
To: | "PGSQL General" <pgsql-general(at)postgresql(dot)org> |
Subject: | Minutes in an interval |
Date: | 2000-09-08 15:41:57 |
Message-ID: | 007501c019ab$57043750$150310ac@pablo |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi!, Evrybody there!
How can I know how much minutes (or hours, or days) are there in an
interval. I mean:
Field T1 value: 01/05/2000 09:00
Field T2 value: 01/05/2000 10:00
T2-T1 gimme 01:00
the function date_part('minute',T2-T1) says 00
But I'd like to get 60
Is there a standar function wich tells the diff. in seconds/minutes or
whatever in an interval.
Now I'm using date_part('epoch',T2) - date_part('epoch',T1)
I had a function in MS SqlServer: datediff(string,date1,date2) --> Integer.
That's what I'm seeking.
By the way, the MS SqlServer went to the hell and I replaced in one day and
one night by the PostgreSQL server I had for testing purposes (The backup
file gave me an unrecovery drive support in the restore of the MS SqlServer
(????!!!!)).
Think we are more than 100 workstations in a 24H / 7 days factory
enviroment.
Since then evrything goes faster and nicer.
Thanks in advance!
Pablo.
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2000-09-08 15:43:13 | Re: type casting varchar to int |
Previous Message | Gilles DAROLD | 2000-09-08 15:30:01 | Re: Perl Module + postgres 7.0.2 |