Forum Stats

  • 3,874,218 Users
  • 2,266,685 Discussions
  • 7,911,771 Comments

Discussions

Date Parameter problem

3004
3004 Member Posts: 204,171 Green Ribbon
In discovere 3.1,
1. A condition Gl Date(from table) = :GlDate (parameter) runs forever and does not return records
2. When I put a to_char(Gl Date, 'dd-MON-yyyy') = :GlDate it gives an error "ORA 01830: Date Format picture ends before converting entire input String"
However it works if I use the DD-MON-YY format.
I am entering the date in the same format as I use in the TO_CHAR function.
Can anyone tell why ?

Comments

This discussion has been closed.