Jump to content

SSMITH001

Members
  • Content count

    1
  • Joined

  • Last visited

Community Reputation

0 Neutral

About SSMITH001

  • Rank
    Newbie
  1. SSMITH001

    Date in a string field

    Help! I can't figure this out... I have a date value stored in a VARCHAR(2) field called RFRC_NUM10. In my where clause, I want to grab all records where this date value is >= sysdate, but I can't seem to get it to work. AND TO_DATE(RFRC_NUM10,'YYYY-MM-DD') >= TO_CHAR(sysdate, 'YYYY-MM-DD')
×