Hi Thank you for reading my post can you please let me know which one of timestamp or datetime is more efficent and portable? We need to store timestamp of an event in database so we can use one of timestamp or date time, which one is more efficent? which is faster in comparsion and easier to port to other databases?
In which case datetime and timestamp represent very different things. The most important difference is that timestamps in SQL Server are not used to store dates and times. They store binary numbers used in row versioning. If you need a datatype to store a date time value, use datetime.