>select cast('10/28/01' as date) + cast('1 day' as interval);
>
>I get 2001-10-28 23:00:00-08, when I expect 2001-10-29 etc. I am using
this in a loop in a pltcl function.
I believe you can use tcl instead of a select:
return clock format [expr [clock scan '10/28/01'] + 86400] -format
"%Y-%m-%d"
This should be every bit as fast as using a SELECT.
len morgan