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. twilliamson

    SYSDATE Year

    I created the following sql statement. However, I do not want to hardcode the date '01-JAN-2012'. I would like to have 01/01 but derive the year from the sysdate. Effdt <> TO_DATE('01-JAN-2012','DD/MM/YYYY');

Part and Inventory Search

Back
Top