Date filter Timestamp issue – Oracle DB
8 November, 2010
We are running 5.0 against an Oracle database.
When Yellowfin reads in the Date field, it recognized it as a Timestamp instead of a Date.
This is disruptive when the field is used in filters as it is forcing the entry of time when doing a > or = operation.
Is there any way to force the view to recognize the field as a Date?
Can we change the defined type in an export of the view and re-import it?
Here is a snippet of the table create script for the table being accessed:
[code]
CREATE TABLE xxxx (
AD_ID NUMBER NOT NULL,
EVENT_DATE DATE NOT NULL,
IMPRESSIONS NUMBER NULL,
[/code]
and a screen cap showing the recognition of that field as a Timestamp.
When Yellowfin reads in the Date field, it recognized it as a Timestamp instead of a Date.
This is disruptive when the field is used in filters as it is forcing the entry of time when doing a > or = operation.
Is there any way to force the view to recognize the field as a Date?
Can we change the defined type in an export of the view and re-import it?
Here is a snippet of the table create script for the table being accessed:
[code]
CREATE TABLE xxxx (
AD_ID NUMBER NOT NULL,
EVENT_DATE DATE NOT NULL,
IMPRESSIONS NUMBER NULL,
[/code]
and a screen cap showing the recognition of that field as a Timestamp.

Hi
In Oracle, the DATE and TIMESTAMP types both include a time component. Because of this, we recognise both as "Timestamp" types, so that we can display the time part.
http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-faq-090281.html#08_01
If you set the Format to "Date" on the Format tab (at the view level), any filters should be displayed as a standard date filter.
In Oracle, the DATE and TIMESTAMP types both include a time component. Because of this, we recognise both as "Timestamp" types, so that we can display the time part.
http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-faq-090281.html#08_01
If you set the Format to "Date" on the Format tab (at the view level), any filters should be displayed as a standard date filter.