Revision: 3719
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at September 5, 2007 19:31 by arunpjohny
Initial Code
/* * Subtracting months */ update employee set dateOfBirth = dateOfBirth - interval '1 months' /* * Adding months */ update employee set dateOfBirth = dateOfBirth + interval '1 months' /* * You can use one of the following intervals *-------------------------------------------- * microseconds * milliseconds * second * minute * hour * day * week * month * quarter * year * decade * century * millennium */
Initial URL
http://www.postgresql.org/docs/8.0/interactive/functions-datetime.html
Initial Description
Initial Title
Date Add/Substract
Initial Tags
Initial Language
SQL