Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cloudtwter

    CASE DATE

    Works...Thanks All.
  2. cloudtwter

    CASE DATE

    Thanks, I tried that earlier with to_number got error..
  3. cloudtwter

    CASE DATE

    SELECT COL1, CASE COL1 when (days(date(SUBSTR(COL1, 1, 4) || '-' || SUBSTR(COL1, 5, 2)|| '-' || SUBSTR(COL1, 7, 2))) > (days(current_date)-365)) THEN 'A' ELSE 'B' FROM TAB1; COL1 is chat(8) storing as date for yyyymmdd Trying to get less/greater than than 1 year old with case as A/B

Part and Inventory Search

Back
Top