Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

retrieve date

 
vicky malhotra
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
vicky malhotra
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic