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 Wanet Telecoms Ltd 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: njaromack
  • Content: Threads
  • Order by date
  1. njaromack

    sort by date problem

    I have a sql query that formats a timestamp to the specs required, but now it does not sort properly and, not being a sql guru, I seem to be stuck. Here is a snippet of my query: to_char((NEW_TIME(to_date('01-JAN-1970','DD-MM-YYYY')+ MB.transmit_TSTMP/86400, 'GMT', 'CST')), 'HH:MI:SS am mm/dd')...

Part and Inventory Search

Back
Top