Retrieve time from SQL

[sarvanjonty]

I am using MSSQL as my backend for ASP.Net.I have to retrieve time from SQL to ASP.Net textbox. The datatype of the field is smalldatetime. The value stored in it is "1/1/1900 12:20:00".How to Retrieve the time "12:20:00" from the field.

Sarvan.M

[Guffa]

You can format the DateTime value into a string with only the time: timeString = daTime.ToString("HH':'mm':'ss");

--- b { font-weight: normal; }

[mbbisht]

DateTime dtTime=Convert.ToDateTime(dateTime); string strTime=dtTime.ToLongTimeString();

Mahendra

[saloni289]

In MSSQL use Convert function:- convert(varchar,date,108)

Saloni