* Ligia Pimentel <[EMAIL PROTECTED]> menulis:
> I need to know if there is a sql function implemented in postgres that gives
> me a date plus any number of days, months or years (the traditional dateadd
> function) or how to do it in sql?
cepat=# select '01-01-00'::date + '2 months 10 days'::interval;
?column?
------------------------
2000-03-11 00:00:00-05
(1 row)
--
Cliff Crawford http://www.sowrong.org/
birthday party cheesecake jellybean BOOM
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html