Received: from corvette.mascari.com (dhcp065-024-161-045.columbus.rr.com [65.24.161.45]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f26JQox62455; Tue, 6 Mar 2001 14:26:50 -0500 (EST) (envelope-from mascarm@mascari.com) Received: from ferrari (ferrari.mascari.com [192.168.2.1]) by corvette.mascari.com (8.9.3/8.9.3) with SMTP id OAA01240; Tue, 6 Mar 2001 14:20:17 -0500 Received: by localhost with Microsoft MAPI; Tue, 6 Mar 2001 14:25:29 -0500 Message-ID: <01C0A649.4BBC29E0.mascarm@mascari.com> From: Mike Mascari Reply-To: "mascarm@mascari.com" To: "'Boulat Khakimov'" , "pgsql-sql@postgresql.org" , "psql-novice@postgresql.org" , "pgsql-general@postgresql.org" Subject: RE: Date question Date: Tue, 6 Mar 2001 14:25:28 -0500 Organization: Mascari Development Inc. X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 Encoding: 40 TEXT X-Archive-Number: 200103/279 X-Sequence-Number: 5762 How about: SELECT '2001-03-06'::timestamp + '1 Year'; Hope that helps, Mike Mascari -----Original Message----- From: Boulat Khakimov [SMTP:boulat@inet-interactif.com] Sent: Tuesday, March 06, 2001 2:20 PM To: pgsql-sql@postgresql.org; psql-novice@postgresql.org; pgsql-general@postgresql.org Subject: [GENERAL] Date question Hi, Im a little bit stuck here. Does anyone know how to get date in format 'YYYY-MM-DD' of a date one year from now. So for example today is '2001-03-06' I need to get date 12 months from now which will be '2002-03-06' in todays case... In mysql I used DATE_ADD(CURDATE(), INTERVAL 12 MONTH) , but that doesnt work in PG. Regards, Boulat Khakimov -- Nothing Like the Sun ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly