Click to See Complete Forum and Search --> : Hour:Minute display


nelslynn
09-19-2003, 04:48 PM
I am querying a database for a field that is in this format: hh:mm (hours, minutes). It is a calculated field of the difference between two times. I'm using ASP and a datalist to display the results... here is where I'm at:

<TD class="text" width="30"><%# DataBinder.Eval(Container.DataItem, "split1") %></TD>

Currently the page displays my field as a full date (date with time and "PM" or "AM"). All I want to display is the hours and minutes in this format: hh:mm

How do I go about this?

Khalid Ali
09-19-2003, 05:51 PM
read this ...you need an asp solution

http://www.aspfree.com/articles/1289,1/articles.aspx