Author: Tomas Rutkauskas
Problem/Question/Abstract:
Today's date on database server
Answer:
This is another case where ORACLE and InterBase differ.
1 2 // make the SQL dependent on type of DBMS3 4 if AppLibrary.Database.DriverName = 'ORACLE' then5 SQL.Add('and entry_date < SYSDATE')
6 else7 SQL.Add('and entry_date < "TODAY"');
8 end;