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 strongm 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: dpit
  • Order by date
  1. dpit

    cast syntax

    I have tried this syntax in business objects (a reporting tool) with Teradata syntax since we are trying to access data. The date field is stored as 20030502. I have written this Cast(substr(IVR.Local_Order_Entry_IVR.DATES,1,4) || '-' || substr(IVR.Local_Order_Entry_IVR.DATES,5,2) ||...
  2. dpit

    BTEQ variables

    I want to write a script that looks back at the last month for a sql query. so how do I store todays date and make two more dates for beginning and end of last month. thanks,

Part and Inventory Search

Back
Top