Search results

  1. J

    Calculated Fields in SQL

    Calculated Field Thanks for your reply. The reason for using the DATE field is that I want the column that is returned to contain the System Date. I have been looking fufther, Would this involve the use of the INTO statement? I can use the "current date" function when I query a DB2...
  2. J

    Calculated Fields in SQL

    I am trying to return a calculated field of the system date on an sql query to a Progress database. I tried the following... SELECT COUNT(DISTINCT AL1."control#"), DATE From ... But I get an error saying that the "DATE" column is not found in the table. Is there a way to return columns...
Back
Top