have database with field where users can enter the schedule time of an event. however, i am using sql server and have field set up as varchar datatype right now. how can i use an actual datetime field where i could only display the time using ASP. this is my code.

Sql = "SELECT dte, eTime, cnumber, text_field, pltatty, defatty, etype "
Sql = Sql & "FROM diary "
Sql = Sql & "WHERE dte= '" & dt & "' "
Sql = Sql & "ORDER BY etime ASC"
objRs.Open Sql, objConn


Do While Not objRs.EOF
Response.Write "<tr>"
Response.Write "<td valign=top align=left>" & "" & objRs("etime") & "<p>&nbsp;</p><p>&nbsp;</p>" & "</td><td valign=top align=left>" & ""
Response.Write "" & objRs("cnumber") & "</td><td valign=top align=left>" & ""
Response.Write "" & objRs("text_field") & "</td><td valign=top align=left>" & ""
Response.Write "" & objRs("pltatty") & "</td><td valign=top align=left>" & ""
Response.Write "" & objRs("defatty") & " </td><td valign=top align=left>" & ""
Response.Write "" & objRs("etype") & "<BR><BR></td><td valign=top align=left>" & "" & vbcrlf
Response.Write "</tr>"
objRs.MoveNext
Loop

Mike

__________________
Mike

Hi,

 Do you want to convert the varchar field in your database as datetime and display in ASP only time..?

If yes then you can use formatdatetime function to display only time from datetime.

Om Prakash

The below code displays the time alone. Replace getdate() with your datetime field name.

Select Convert(char(10), getdate(), 114)

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

thanks vladivel/om_prakash, used formatdatetime and it worked.
thanks a bunch.

Mike