Request a Demo
Home   >   mailing lists

Getting number of days - Mailing list pgsql-sql

From Webb Sprague
Subject Getting number of days
Date
Msg-id 20000927190916.27309.qmail@web801.mail.yahoo.com
Whole thread Raw
List pgsql-sql
Tree view 
Hi All,

Does anybody know how to convert an interval into a
number of days.  Say I have something like '2 years 4
months 4 ago', I need to get the total number of days,
something like 800 (ish).  Is there a built in
function?

Thanks
W

__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/

pgsql-sql by date:

Previous
From: Keith Wong
Date:
Subject: Setting the transaction isolation level for a stored procedure
Next
From: Joachim Trinkwitz
Date:
Subject: copying/moving from one table to another