Changing Format Of Data In Gridview Using VB

Hello all,

I am trying to modify the output of a SELECT statement in a VB asp.net page that pulls data from a SQL DB. I only need to modify one column in the gridview, but I'm having some issues.

Here is the situation:

SELECT     TOP 24 ID, RecID, Timestamp, Answered, Holds, Dropped, Waits, Voicemail, Busied, LiveWaits
FROM         mTraffic
ORDER BY Timestamp DESC

The Timestamp column returns a number value (i.e. 564566).

In terms of a date, 564566 doesn't mean anything to the user, so I need to convert this number into a recognizable and accurate date.

The formula I need to implement is Timestamp/1440 - 1

The following SELECT statement returns the number as a date, but makes all records the same date:

SELECT     TOP 24 ID, RecID, Convert(datetime, Timestamp/1440 + 1) as Timestamp, Answered, Holds, Dropped, Waits, Voicemail, Busied, LiveWaits
FROM         mTraffic
ORDER BY Timestamp DESC

What do I need to do to implement this function dynamically into my gridview?

Thanks in advance!

 

Chris