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