Use the to_date function on the field you are selecting. Michael Kear wrote:
>I have a need for a query selecting on date being between <this> and <that> >dates set in a form by the user. No problem there. > >Except the dates are stored in the oracle database as varchar strings >ddmmyyyy. I can't see how to select based on dates in that format, can you? >I'm not going to be selecting on specific dates, but between date values, or >older than a specified date. > >Any ideas on how I can SELECT * from TABLENAME if DATE less than <form.date> >? > >OR date between <this> and <that>? > > > > >Cheers, >Michael Kear >Windsor, NSW, Australia >AFP Webworks. > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://affiliates.macromedia.com/b.asp?id=2439&p=go/fl_aff1 Message: http://www.houseoffusion.com/lists.cfm?link=i:6:1748 Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:>
