Select * from Visit where vis_mod_dt between today-365 and today;

select * from visit where date(vis_mod_dt) between today-365 and today;

dbschema -d dbase -t visit

export DBDATE=DMY4/

SELECT t.tabid, t.tabname, c.colno, c.colname, c.coltype, c.collength
  FROM "informix".systables AS t, "informix".syscolumns AS c
 WHERE t.tabid = c.tabid
   AND t.tabname = "visit"
 ORDER BY t.tabid, c.colno;

SELECT TODAY, TODAY-365 FROM "informix".systables WHERE tabid = 1;