Date Error

[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.