Skip site navigation (1) Skip section navigation (2)

Re: Is there a way to get just the number of seconds between two timestamps?

From: Michael Lush <mjlush(at)ebi(dot)ac(dot)uk>
To: A B <gentosaker(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Is there a way to get just the number of seconds between two timestamps?
Date: 2009-04-08 15:36:38
Message-ID: Pine.LNX.4.64.0904081632560.6094@pigeon.ebi.ac.uk (view raw or flat)
Thread:
Lists: pgsql-novice

On Wed, 8 Apr 2009, A B wrote:
> I want to just get the number of seconds and not have to use extract
> for seconds, minutes, hours, days, months, years, etc.
> Is that possible?

I suppose you could write your own procedure and get a nice new round 
thing (if your lucky,  you could reinvent the square wheel:-)

What is wrong with EXTRACT?

--
Michael
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Michael John Lush PhD			Tel:44-1223 492626
Bioinformatician 
HUGO Gene Nomenclature Committee	Email: hgnc(at)genenames(dot)org
European Bioinformatics Institute
Hinxton, Cambridge
URL: http://www.genenames.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2009-04-08 15:36:48
Subject: Re: scripts for the tutorial
Previous:From: Steve CrawfordDate: 2009-04-08 15:26:04
Subject: Re: Is there a way to get just the number of seconds between two timestamps?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group