* 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

Reply via email to