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

Collapse
2: Re: Using bind variables with Oracle dates (response to 1)
Posted by Brian Fenton on 01/26/12 05:19 PM
I figured out what was wrong....me! 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.