pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

How do I convert an interval into integer?
2+ messages / 2 participants
[nested] [flat]

* How do I convert an interval into integer?
@ 2003-12-04 18:09 Wei Weng <wweng@kencast.com>
  2003-12-04 18:26 ` Re: How do I convert an interval into integer? Tomasz Myrta <jasiek@klaster.net>
  0 siblings, 1 reply; 2+ messages in thread

From: Wei Weng @ 2003-12-04 18:09 UTC (permalink / raw)
  To: pgsql-sql

I want to convert an interval (from substraction between two timestamps) into 
a integer that represents how many seconds that interval has. How do I do 
that?

I am using postgresql 7.3.1

Thanks



Wei




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: How do I convert an interval into integer?
  2003-12-04 18:09 How do I convert an interval into integer? Wei Weng <wweng@kencast.com>
@ 2003-12-04 18:26 ` Tomasz Myrta <jasiek@klaster.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Tomasz Myrta @ 2003-12-04 18:26 UTC (permalink / raw)
  To: Wei Weng <wweng@kencast.com>; +Cc: pgsql-sql

Dnia 2003-12-04 19:09, Użytkownik Wei Weng napisał:

> I want to convert an interval (from substraction between two timestamps) into 
> a integer that represents how many seconds that interval has. How do I do 
> that?

select extract(epoch from your_interval);

Regards,
Tomasz Myrta




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2003-12-04 18:26 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-12-04 18:09 How do I convert an interval into integer? Wei Weng <wweng@kencast.com>
2003-12-04 18:26 ` Tomasz Myrta <jasiek@klaster.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox