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: sunny567
  • Content: Threads
  • Order by date
  1. sunny567

    Convert date in char to SAS date

    Friends, I have a db2 date unloaded in character format eg. 31.12.2005 (DB2 length=10). I need to convert it into a SAS date format before writing to a SAS dataset. How can I do this? Please help. Also how to handle the timestamp (DB2 length=26). also what is the SAS datatype for DECIMAL(11,2)...
  2. sunny567

    Date criteria in SQL query (+FETCH)

    Hi, I am using SAS to access DB2 tables. I have a very complex join of large number of tables which is taking ages to complete running (batch). I would like to add a date criteria to the query. Will this work - in SQL query -> where date_field > date()-60. Don't I need to convert the value...

Part and Inventory Search

Back
Top