> } if I do "select Current_Date + interval '7 days'; I get:> } 2002-11-25 00:00:00-06
Another option is to use:select current_date + 7;As long as you are moving by days (not months, years, hours etc.), thisis probably the simplest solution.