Loading

How do i convert TimeStamp to DateTime?

petre ricardo

Hi,
I have a DB table that has a TimeStamp column and i need to dispplay that in my DataGridView Controller. When i tried to lead the data of that column, it throws an exception in a data Grid View Deafult error log, and prevents from displaying the time stamp values.. How do i fix this?
TY

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Roei Bar17y ago
There is no datatype called Time in SQL Server
The only way is to use Convert function

select convert(varchar,CAST (0x00000000000067FB as datetime),10)
0
Kirtan Patel17y ago
Its Bug :)

binary columns by default in gridview read as image, in your scenario VS tries to convert your binary data (timestamp)

to image so it fails so it throws exception!!

http://connect.microsoft.co/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=93639

By AutoGenereted Columns it Generates ImageColumn For TimeStamp

you need to Manually Add textColumn for TimeStamp Data.. in dataGridView :)

Thank you :)

and please check "do you like this answer" :)

0