Post reply

Regarding time stamp retrieval

  • July 9, 2010 at 3:42 am

    #63825

    Hi,

    Can anyone tell me

    How do i retrieve the Time stamp of the inserted record without adding the timestamp columns to the table used.

  • July 9, 2010 at 4:42 am

    #1190695

    You're wanting to retrieve a value that you're not actually storing anywhere?

    Or do you mean that you want to return whatever the current timestamp is at the time of insertion? And do you mean the timestamp value, or the current datetime?

  • July 9, 2010 at 6:13 am

    #1190731

    Jim is right, there is no hidden field anywhere that tracks WHEN an item was inserted or updated. if you don't have a column for it, you'll have to add it eithe rto the table, or to an auditing table with a trigger.

    another alternative is a DML Data Manipulation Language trace, which could be used to track when changes occur, but is not as granular as a field in the data row itself. a trace can capture the UPDFATE statement, and you can infer that the column changed, but itwouldn't show old/new values in the trace.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • July 9, 2010 at 6:25 am

    #1190749

    Yes I want to retrieve a value that I m not actually storing anywhere?

    I am Not taking any columns for creation date or modification date in tha table and storing it but i want the values.

    Is it possible by accessing in anyway the log files...

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply