Date Error

[system]

I am trying to create a new object for today date.
Object Name: Today (dtm)
Select: SYSDATE from DUAL

Getting Error: Parse failed: Exception: DBD, ORA-00933: SQL command not properly ended State:N/A

I used this object in report and there is also error

Error: The query does not reference any table when attempting to build the WHERE clause. (Error: WIS 00022)

---

khalidlatif7868 (BOB member since 2012-11-05)

[system]

Why don’t you use CurrentDate function in Webi Report.

---

RUC (BOB member since 2010-05-03)

[system]

You’ll get an error because you’re not referencing a table in your webi report. Drop another object in and you’ll find it works perfectly!

Debbie

---

Debbie (BOB member since 2005-03-01)

[MarkP]

@khalidlatif7868

I am trying to create a new object for today date.
Object Name: Today (dtm)
Select: SYSDATE from DUAL

Getting Error: Parse failed: Exception: DBD, ORA-00933: SQL command not properly ended State:N/A

I used this object in report and there is also error

Error: The query does not reference any table when attempting to build the WHERE clause. (Error: WIS 00022)

Welcome to B B

Please refer to the Relative Dates Topic for more information.

What Debbie says is absolutely spot on.

Don’t use DUAL - you’ve been asked for a SELECT statement in your obejct definition, not a SELECT x FROM y statement.
SYSDATE will give the current date and time
TRUNC(SYSDATE) will give today’s date

Neither will parse in Designer because the parsing algorithm expects select statements in the form table.column (or similar) so that it can parse them.