Re: Interval examples

George Robinson II wrote:
>
>         Could someone please send me some examples of the interval data type?
> For example, what should the data look like in order to do and insert?
> If I have two iso time stamps, how can I insert them into the interval
> datatype?  What are some ways to format the output of an interval type?
>
>         Note: When working in perl, I have found the "Perl Cookbook" the most
> valuable asset I have.  I think we should get together and produce a web
> site where people can submit various type of code involving postgres, so
> that newbies (such as myself) have lots of material to learn from.  I'll
> have plenty of examples to submit when I'm done with this project.  And
> I'd do it myself, but I'm not really a web guy.
>
>         Thanks for the help

select interval( datetime('now') - datetime('today'));
     interval
-------------------
 @ 28 mins 32 secs
(1 row)

Just as a suggestion...

Cheers,
                    Andrew.
--
_____________________________________________________________________
            Andrew McMillan, e-mail: Andrew@cat-it.co.nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267