function_sysdate_now.sql

来自「AbsDataBase5.16 最新版」· SQL 代码 · 共 9 行

/*This SQL script uses Demos.abs database. 
  Please open ...\AbsoluteDatabase\Demos\Data\Demos.abs database file.
  This sample illustrates use of SYSDATE and NOW functions.
  The query retrieves all events that have occured already. Notice that functions NOW and SYSDATE do same things and you can use either.*/

select e1."Event_Name", e1."Event_Date", (sysdate) as "CurDate"
  from "events" e1
 where (e1."Event_Date" < now)