retrieve date

Hi!

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.

Thanks

[Bear edit: not so urgent]
[ March 21, 2005: Message edited by: Bear Bibeault ]

Vicky,
Are there any database logs that you could look at? That's a long shot, but it's all I can think of. A database doesn't usually store more precision than you tell it to.

Hi Jeanne,

i do have the application logs and i can take the date from there, but not all logs are there. So i was looking if the DB does store the date of inserted records.

Anyways, thanx.