Today's date on database server (Views: 31)
Problem/Question/Abstract: Today's date on database server Answer: This is another case where ORACLE and InterBase differ. // make the SQL dependent on type of DBMS if AppLibrary.Database.DriverName = 'ORACLE' then SQL.Add('and entry_date < SYSDATE') else SQL.Add('and entry_date < "TODAY"'); end; |