Timestamp

[EPNICO]

Hello:

In MS SQL version 7.0 is there a way to query a timestamp field so I can get an an exact date? In my research for this I found a Teck-tip that mentions that you cannot query a timestamp field?

Thanks for any ideas.

 

[fluteplr]

Create a datetime or smalldatetime field depending on how accurate you need the time to be. Set the default to getdate().

 

[tlbroadbent]

You can not get a meaningful datetime from a SQL Server timestamp field. Unfortunately the TIMESTAMP data type is misnamed. It is not a real timestamp but rather an 8 byte binary field that that changes every time a row is updated. Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm