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 IamaSherpa 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. charoian

    SQL- find records that are NOT the first or the last day of the month

    This forum can't upload attachments so here's the SQL; --Find all Risk valuations that are not the first or last day of the month: SELECT * FROM valuation WHERE 1 = 1 AND valuationtime < '01jan08' AND (To_Char(valuationtime, 'DD') != '01' OR To_Char((valuationtime + 1), 'DD') !=...
  2. charoian

    SQL- find records that are NOT the first or the last day of the month

    SQL script to find and delete records that are not the first or the last day of the month. It correctly returns records with dates prior to 01 Jan 08. However, it is returning first day of month and last day of month records. (see attached)

Part and Inventory Search

Back
Top