Current date in Oracle Db

Try this:

SELECT "DATE", BUS, VALUE
FROM {your_table}
WHERE "DATE" >= trunc(sysdate) and "DATE" < trunc(sysdate+1)

Browse More Popular Posts

Leave a Comment