building default_where string containing date values [message #78944] |
Fri, 05 April 2002 03:35 |
Stephen Agbodza
Messages: 4 Registered: February 2002
|
Junior Member |
|
|
Hi folks,
i am trying to query a block by building a default_where string in the ff format
requested_from = <value1> and request_date between <date1> and <date2>
value1 is a varchar2, date1 and date2 are in the format dd-mon-yyyy.
All values are entered in the form.
I am at a loss. Please help.
|
|
|
Re: building default_where string containing date values [message #78950 is a reply to message #78944] |
Fri, 05 April 2002 19:18 |
rama krishna
Messages: 97 Registered: December 2001
|
Member |
|
|
set_bloc_propert('block_name',default_where,'requested_from ='||''''||value1||''''|' and request_date between '||to_date(date1'dd-mon-yyyy)||' and '||to_date(date2'dd-mon-yyyy)
hope this will work. the character should be always put in quotes. and try always use to_date with dates...
cheers
ram
|
|
|