Informix iSQL date function help

Question

I'm trying to extract just the year out of either of the built-in date functions of Informix TODAY or CURRENT

Is there a way to do this without SUBSTR()?

Answer 1

Yes: use the YEAR function:

SELECT YEAR(TODAY)
  FROM SysMaster::SysDual;

Similarly for MONTH, DAY, WEEKDAY (0..6). You could use CURRENT instead of TODAY, but that generates a DATETIME value which is then converted to DATE and then analyzed.