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!

Recent content by javydreamercsw

  1. javydreamercsw

    convert long int to date

    Thanks, the answer is: SELECT to_date('1-JAN-1970')+F_SGTM/(24*60*60) FROM SGRP_EXT Figured it out just a couple of mins before I got your email but thanks anyways!
  2. javydreamercsw

    convert long int to date

    And by the way how I could do that calculation in the sql statement?
  3. javydreamercsw

    convert long int to date

    Is there a way to getbase date?
  4. javydreamercsw

    convert long int to date

    I tried this answer but didn't work, what I've found is that in my case the type is long(4). What modifications shall be done? Values are like : 1114582520
See more

Part and Inventory Search

Back
Top