| add 45 days in a date. [message #10568] |
Sat, 31 January 2004 00:24  |
shahzad-ul-hasan
Messages: 615
Registered: August 2002
|
Senior Member |
|
|
dear sir,
i am facing a problem.
i have a inv. date and i want to add 45 days in the inv.Date..which is the function and query is to help us....
thx
|
|
|
|
| Re: add 45 days in a date. [message #10569 is a reply to message #10568] |
Sat, 31 January 2004 01:30  |
 |
Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
Assuming that the inventory date column is of date datatype, then,
to just select it:
SELECT inventory_date_column + 45 FROM your_table;
or to change the value in the table:
UPDATE your_table
SET inventory_date_column = inventory_date_column + 45;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
