Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Location
    Lowlands
    Posts
    53

    Unanswered: Retrieve insertiondate

    Hi folks,

    Does anyone know how to retrieve the date when data has been inserted

    thnx in advance
    If Perfection really is an Illusion. Then I want to get as close as possible to that Illusion.

  2. #2
    Join Date
    Dec 2002
    Location
    Antwerp, Belgium
    Posts
    227
    You can create a column of the datetime data type. Set the default for that column to "getDate()". This should give you a value of the current date at the time of the insert.
    Johan

  3. #3
    Join Date
    Dec 2003
    Location
    Lowlands
    Posts
    53
    thnx for your reply,

    I know that I can solve it like you suggested, but I want to know the insertiondate of a excisting record..

    Can't I retrieve this info with the system tables or something like that

    thnx in advance
    If Perfection really is an Illusion. Then I want to get as close as possible to that Illusion.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Generally, no.

    I suppose you could restore an old copy of the database and just start restoring transaction logs until the record you are looking for pops up, but I'm guessing you don't have a full-time employee to devote to this for the next week.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Dec 2003
    Location
    Lowlands
    Posts
    53
    I wish I had,

    But thnx for sharing that with me, now I can leave it and go further

    thnx
    If Perfection really is an Illusion. Then I want to get as close as possible to that Illusion.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •