converting an SQL timestamp to/from a real date

  • Thread starter Thread starter news.microsoft.com
  • Start date Start date
N

news.microsoft.com

In vb.net, is there anyway to convert a SQL timestamp field into a real
date. Also can I convert a real date into a SQL timestamp
 
A SQl Server timestamp column is not a date at all.

It is a binary representation of a number.

Cast it as int to see it's value.
 

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

help with sql command--quickie hopefully 4
Converting OLE Automation Dates back into regular date/time? 2
>> sql timestamp 4
Date Timestamp 1
How to convert a byte() to string 4
time formatting error 2
converting a hex timestamp to a readable date/time 1
How to get SQL timestamp value using VB.NET 4

Back
Top