Informix add days to date Redirecting to /docs/en/informix-servers/14. If you convert DATETIME YEAR TO DAY to the DATE format, the value 2002-08-15 becomes 08/15/2002. Only Informix® supports SYSDATE. The DATE function interprets the first part of the date string (02) as the year and the second part (01) as the month. You can also use the CURRENT or SYSDATE function to return a value with the current date and time, or use the EXTEND function to adjust the precision of a The time functions of Informix accept DATE or DATETIME arguments, or character representation of a DATE or DATETIME value. The following query uses the DAY and CURRENT functions to compare column values to the current day of the month. Instead, you must use 2008-10-30 or 08-10-30 as the DATETIME string. You can also subtract one DATE value from another DATE value, but the result is a positive or negative INTEGER count of days, rather than an INTERVAL value. The following examples demonstrate this. You can customize the DATE format that the database server expects with the DBDATE and GL_DATE environment Jul 7, 2008 ยท You can use the DATE or TO_DATE function to convert a character string to a DATE value. y5fro osoav sevez ynwa4t 918 uu n3rae ahp hm1b5 c6w344qe