http://dashboard.infocaptor.com/ Dashboard Discussion, Support, Examples, Help Topic: Dashboard Date in Oracle Where Clause en Sat, 11 Sep 2010 02:07:01 +0000 http://dashboard.infocaptor.com/topic/dashboard-date-in-oracle-where-clause#post-57 Thu, 12 Mar 2009 23:18:31 +0000 admin 57@http://dashboard.infocaptor.com/ <p>Hello Semma,</p> <p>The default date format for the date picker is dd-MMM-yyyy (e.g 01-Jan-2009). Assuming this format is not changed in the Date properties</p> <p> Try the where clause as below (NOTE: there is no need to convert to to_char and then to date)</p> <p>where invoice_date between to_date('G_PARAM&lt;34:Display&gt;','DD-MON-YYYY') and to_date('G_PARAM&lt;63:Display&gt;','DD-MON-YYYY')<br /> group by country_desc order by amount desc </p> http://dashboard.infocaptor.com/topic/dashboard-date-in-oracle-where-clause#post-56 Thu, 12 Mar 2009 10:50:02 +0000 semma 56@http://dashboard.infocaptor.com/ <p>Hello,<br /> I am using your dashboard date picker, but it doesn't appear to be giving expected results in my where clause in Oracle. Here's my where clause:</p> <p>where<br /> invoice_date between to_date(('G_PARAM&lt;p34:Display&gt;'),'dd:mon:yyyy') and<br /> to_date(to_char('G_PARAM&lt;p63:Display&gt;'),'dd:mon:yyyy')<br /> group by country_desc order by amount desc </p>