SQL Timestamp and VB Type ?

How do I pass a sql Timestamp to a function in VB - what type is the Timestamp?
JulypoboxAsked:
Who is Participating?
 
Bob LearnedCommented:
Timestamps are binary numbers, which I believe are represented as a byte array.
0
 
Bob LearnedCommented:
Timestamps vs Datetime data types
http://www.sqlteam.com/article/timestamps-vs-datetime-data-types

<Quote>The SQL Server timestamp data type has nothing to do with times or dates. SQL Server timestamps are binary numbers that indicate the relative sequence in which data modifications took place in a database. The timestamp data type was originally implemented to support the SQL Server recovery algorithms.</Quote>

What are you using the Timestamp data type for?
0
 
JulypoboxAuthor Commented:
to send to stored procedure to know whether record has been modified... I'm using optimistic locking...  And in the vb code I might pass parameters to another function to do the actual work, like when I'm deleteing I have on sub do the setup/call to sp which reqires the record ID (to know what to delete) and the timestamp. So passing this within my vb code to the sub that does the delete is where I'm stuck.

Private Sub DeleteRow(byval ID as int, byval modified as ??????????)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.