retrieving date and time????

[Prett]

Hello,
Please tell me how to retrieve the date and time when a row was inserted in the database? Is that logged in the transactional log?
thank you! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Thalian]

Try to add a TIMESTAMP column and that will automatically be updated with the current date/time when the row is inserted or updated. Or, add a DATETIME column. In your INSERT statement, use NOW() as the value to be inserted in that column. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --