Convert SQL Timestamp from Byte to readable date

Posted on 2005-05-02
Last Modified: 2008-01-09
Hi All,

I need to know how to convert a SQL Server timestamp from byte format to a readable date value?  I'm trying to pass this value to a label within a datagrid and it is currently returning System.Byte[]. (ASP.NET VB)

Question by:tim_chamberlain
    LVL 28

    Accepted Solution

    Timestamp in SQL Server is not of datetime data type.  If you want a date value returned from SQL Server, you use the DateTime data type, not timestamp.

    Author Comment

    Fair enough. Thanks.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    This article discusses the ASP.NET AJAX ModalPopupExtender control. In this article we will show how to use the ModalPopupExtender control, how to display/show/call the ASP.NET AJAX ModalPopupExtender control from javascript, how to show/display/cal…
    Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now