Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) 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
Sheriff
Posts: 35977
422
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.
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!