[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 336
  • Last Modified:

SQL Timestamp and VB Type ?

How do I pass a sql Timestamp to a function in VB - what type is the Timestamp?
0
Julypobox
Asked:
Julypobox
  • 2
1 Solution
 
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
 
Bob LearnedCommented:
Timestamps are binary numbers, which I believe are represented as a byte array.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now