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 SkipVought 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: *

  • Users: dgo
  • Order by date
  1. dgo

    sql question

    Try this : select to_date('01-JAN-02','dd-MON-yy') + rownum - 1 day from all_objects where rownum <= to_char(add_months(to_date('01-JAN-02','dd-MON-yy'),1)-1,'dd')
  2. dgo

    Query Using Sysdate-1

    trunc(sysdate) gives a time of 00:00

Part and Inventory Search

Back
Top