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 gkittelson 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: raged
  • Order by date
  1. raged

    format a string to be a 24 hour date

    Please help me - I need to format the following string to be a 24 date. I can get it to work for 12 hours.... TO_DATE('25-Sep-00 11:29:40','DD-MON-YY HH:MI:SS') but if I try: TO_DATE('25-Sep-00 18:29:40','DD-MON-YY HH:MI:SS') it says hour must be between 1 and 12 - I need a 24 hour version...

Part and Inventory Search

Back
Top