Forum OpenACS Q&A: Re: Using bind variables with Oracle dates

Posted by Brian Fenton on
I figured out what was! In fact, I somehow knew the right way to do this but managed to confuse myself. The right thing to do is:

set start_date [template::util::date::get_property linear_date_no_time $start_date_param]
append where_clause " and ax.start_date >= to_date(:start_date, 'yyyy mm dd') "

Happy binding.