gigiauss Posted August 1, 2007 Share Posted August 1, 2007 Performing the [query] with [ireport] goes in error ….. Some me Can I/he/she/we/they/you help? sensed [and]_gives ( MiaData, 'Dd/mm/yyyy' ) >= sensed_gives ( [sysdate], 'Dd/mm/yyyy' ) The MiaData field are a gives. Link to comment Share on other sites More sharing options...
nittu02 Posted August 9, 2007 Share Posted August 9, 2007 not quite sure what u meant.. if thats the to_char problem, not sure why you gave sysdate inside square brackets. Link to comment Share on other sites More sharing options...
jmurray Posted August 10, 2007 Share Posted August 10, 2007 You don't need to apply to_date to sysdate: it's already in date format! your WHERE clause should be more like TO_DATE(MiaData,'DD/MM/YYYY') >= sysdate Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now