I have a sql field called OrderTime.. smalldatetime in SQL 2000 length 4
I have the following in my code:
ffSql.OrderTime = Now.ToString("hh:mm:ss tt")
When I try to insert this into my table. If I replace the top with
ffSql.OrderTime = Today
instead of
ffSql.OrderTime = Now.ToString("hh:mm:ss tt")
What I want is to place the time into the field not the date and time.
Can someone help?