I have an application wherein i insert some records into the database. i also have a field called date which is date YEAR TO YEAR (Informix). So it takes only the year. But now i need the day and month also. Is there any way by which i can retrieve the day and month when these records were inserted. If i simply alter the table and convert this date to date YEAR TO DAY, then it makes the day n month as 1 by default.
Please if any one has any idea, reply soon.
[Bear edit: not so urgent] [ March 21, 2005: Message edited by: Bear Bibeault ]