Interested in buying ad space on this blog?
You can, on BuySellAds.com
Do you train Kung Fu?
Or know someone who does?
Then check out KungFuPeople.com
Mobile version of this pagePrevious:
PayPalSucks.com, can't be good for PayPal
Next:
Techie things I want to buy from ebuyer.com
Creating a user for postgresql
Date formatting in python or in PostgreSQL
Integer division in programming languages
Running simple SQL commands on the command line
pg_class to check if table exists
List of casts in PostgreSQL
Just Oracle and IBM?
ALTER TABLE patch
Quick PostgreSQL optimization story
Date formatting in Python or in PostgreSQL (part II)
Sorting transform function in PostgreSQL
Speed test between django_mongokit and postgresql_psycopg2
To sub-select or not sub-select in PostgreSQL
Why bother with MySQL...
UPPER vs. ILIKE
Date plus years or months or weeks
Save this page in del.icio.usPayPalSucks.com, can't be good for PayPal
Next:
Techie things I want to buy from ebuyer.com
Related blogs
PostgreSQL, MySQL or SQLiteCreating a user for postgresql
Date formatting in python or in PostgreSQL
Integer division in programming languages
Running simple SQL commands on the command line
pg_class to check if table exists
List of casts in PostgreSQL
Just Oracle and IBM?
ALTER TABLE patch
Quick PostgreSQL optimization story
Date formatting in Python or in PostgreSQL (part II)
Sorting transform function in PostgreSQL
Speed test between django_mongokit and postgresql_psycopg2
To sub-select or not sub-select in PostgreSQL
Why bother with MySQL...
UPPER vs. ILIKE
Date plus years or months or weeks
Related by category
Adding a year in PostgreSQL
http://www.postgresql.org/docs/7.4/s...tml#OPERATORS-DATETIME-TABLE4th of February 2004
Finally I found it. How to add one year to a date in PostgreSQL
SELECT
date('now') + interval '1 year' AS today_in_one_year,
date '2003-12-13' + interval '1 year' AS my_next_birthday ;
date('now') + interval '1 year' AS today_in_one_year,
date '2003-12-13' + interval '1 year' AS my_next_birthday ;
Both return a TIMESTAMP type.
UPDATE: It doesn't return a TIMESTAMP type, it's a DATE type (only 4 bytes).
To get a TIMESTAMP you can do this:
SELECT '2003-12-13' + interval '1 year' AS my_next_birthday;