Mirror

Today's date on database server (Views: 102)


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;

<< Back to main page