morinia
asked on
using sysdate in an Oracle query
Experts,
Does anyone know the syntax in Oracle to find a date?
Examples:
the first day of the current month
The first day of the current week
Does anyone know the syntax in Oracle to find a date?
Examples:
the first day of the current month
The first day of the current week
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
don't do TO_DATE() on SYSDATE, it's already a date
just put the TRUNC directly against the sysdate result as shown in the first post