function_tostring.sql

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

/*This SQL script uses Demos.abs database. 
  Please open ...\AbsoluteDatabase\Demos\Data\Demos.abs database file.
  This sample illustrates use of TOSTRING function.
  The query retrieves all events that have occured already together with formatted date.*/

select e1."Event_Name", 
  (tostring (e1."Event_Date", """Event date is ""mm/dd/yyyy hh24:nn:ss ""!""")) as "Formated_Date"
  from "events" e1
 where (e1."Event_Date" < now)