How to find the date when the row was inserted?

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

I need to know the date when the row was inserted into a table in sql server. I want to know the date for updating the values from the concerned date.

Posted 25-Nov-12 21:55pm

Anaya Upadhyay

Add a Solution

3 solutions

Solution 1

If you have the proper logging enabled you might find it in there, but SQL does not store an insertion date for each row.

If you need this than you need to include the date[^] into your table design.
You can use CREATE DEFAULT[^] so that newly added rows get the current date automatically.

Posted 25-Nov-12 22:02pm

André Kraak

Comments

Anaya Upadhyay 26-Nov-12 4:34am

I agree to your answer, but...

As we get the last modified date of a table, can't we get the last modified or inserted date of a row??

I need to know the actual inserted/updated date of a row while selecting the table. Help.

André Kraak 26-Nov-12 4:38am

As long as you store these dates with the row yourself, you can.

So add a creation/insertion date and mutation date to the table and fill them. Then you can use them to select your rows.

Prasad Guduri 27-Nov-12 4:04am

Until you store these details in database it is not possible to get those details...!!!!

Maintain a separate column in table to store record created date&time.

Solution 2

for storing insertion detail's datetime
create column say it InsertionDate
now, set it's default value = GetDate()

for update datetime
create column say it UpdateDate
1. now, set it's value when updating query
example: update tbl set updateDate=getdate(),col1=1,col2='hello' where ...
2. or set column's datatype = timestamp column

Happy Coding!
:)

Posted 26-Nov-12 1:16am

Aarti Meswania

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Anaya Upadhyay · Accepted Answer · 2012-11-27T17:01:00

Thank you for your help.

But i had some thousand rows already in my table. I just wanted to know the row insertion date to simply add english date to a new column for each row.

I solved it by converting nepali date (which was already in the table) to english date to this new column.

Thank you all again.