Hello All…
We have START and END DATE prompt for report. The BO create query like:
STATTABLE_DATE BETWEEN 01-06-2009 00:00:00’ AND 11-06-2010 00:00:00’
When NLS_DATE_FORMAT is dd-mm-yyyy hh24:mi:ss on database. It works.
Our concern is, is this will create problems everywhere where the nls_date_format is not in the form of dd-mm-yyyy hh24:mi:ss.
OR
Does BO internally first set the NLS_DATE_FORMAT of oracle session to “dd-mm-yyyy hh24:mi:ss” before firing the query?
Awaiting for your replies.
Thanks in advance.
Vills 
(BOB member since 2007-10-24)