[GENERAL] Re: [SQL] Date question

[Jie Liang]

you can say:

(now() + '1year'::timespan)::date

Jie LIANG

St. Bernard Software

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

[EMAIL PROTECTED]
www.stbernard.com
www.ipinc.com

On Tue, 6 Mar 2001, Boulat Khakimov wrote:

 Hi,
 
 Im a little bit stuck here.
 
 Does anyone know how to get date in format '-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 2: you can get off all lists at once with the unregister command
 (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
 


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: [ADMIN] Re: [GENERAL] what means INSERT xxx yyy ?

[Jie Liang]

I believe that first number is oid.

Jie LIANG

St. Bernard Software
Internet Products Inc.

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

[EMAIL PROTECTED]
www.stbernard.com
www.ipinc.com

On Thu, 15 Feb 2001, Richard Huxton wrote:

 From: "Jean-Arthur Silve" [EMAIL PROTECTED]
 
  Does anyone knows what means, after an INSERT for exemple the message :
 
  INSERT 19331808 1
 
  What the meaning of the two numbers ?
 
 Sorry - don't know what the first number is - I'm getting 0 here on testing.
 The second is the number of rows inserted.
 
 - Richard Huxton