var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Date arithmetic operations..
is there any DATE arithmetic functions to add or subtract days to a date(TIMESTAMP) variable or column.
select current date + 5 days, current timestamp - 5 days
With kind regards . . . . . SQL Server 2000/2005/2012
Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages
yes, if the column is a DATE or TIMESTAMP simply code:
SELECT column-name + 1 DAY
SET column-name = CURRENT DATE + 1 MONTH ...
Wim , Umayer thanks for the help, it works fine now
Last edited by Shefu; 02-01-06 at 08:48.