... - Mailing list pgsql-jdbc

From apratim sharma
Subject ...
Date
Msg-id 20030413061947.62436.qmail@web21110.mail.yahoo.com
Whole thread Raw
Responses Re:
Re:
List pgsql-jdbc
hi,
 
Can anybody tell how to add an integer to a date inside postgres query.
 
i'm using postgres 7.3
 
when i give    select cast(now() as date) it gives the current date,
now i want to select a date say after 10 days.
i'm giving select cast(now() as date) +10 ; it gives error can't typecast date to int
 
what to do???
 
please help me
 
Apratim
 



Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more

pgsql-jdbc by date:

Previous
From: Barry Lind
Date:
Subject: Re: patch for cursor based querys in JDBC
Next
From: "Jordan S. Jones"
Date:
Subject: Re: