APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

To_date a date column?

Richie VOct 31 2018 — edited Nov 1 2018

I was having a problem getting any results when running this query

select * from table1 where bill_date = to_date('10/17/2018', 'MM/DD/YYYY') -- now the "bill_date" column already is in a date format

The query only worked because I had to to_date the bill_date column, but I'm not sure why? Its already in the correct date format. Does that mean that some other character like maybe a blank space is present?

I'm not sure, but I know I shouldn't have to convert a date column into a date format.

Anyone know what I'm missing here?

This post has been answered by fac586 on Oct 31 2018

Jump to Answer

Added on Oct 31 2018

#apex-discussions

4 comments

13,196 views