How can I create a field and function as timestamp in SQL Server

  • Thread starter Thread starter BCat
  • Start date Start date
B

BCat

Dear all,

pls help, is there any data type can work as timestamp in mssql server?

Thanks
 
Hi,
depends on what you want from this timestamp. to make a "system" timestamp
which help access to locate records - just add a field with type timestamp
if you need a field with date, which shows last update - then add a datetime
field and make a trigger to set this field to current time at any update

--
Best regards,
___________
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Timestamp field for Access use 28
Timestamp wth MY sql 2
Formatting Question 2
>> sql timestamp 4
Insert or update record with vba and ado 2
Reference a table field in VBA 1
DLookUp field in previous record on a filtered form 1
Parsing a Timestamp 5

Back
Top