hour??

[farizza]

hello
i have a textbox in the form load i write
Format$(time, "hh:mm:ss").
when i insert this in the database(SQL Server7)
insert this 1/1/1900 12:30:55 actual hour

what is the problem????

[courchjo]

I had that problem earlier and do like this with no problem:
strSQL = strSQL & chr(39) + Format(Time, "hh:mm:ss") + chr(39)

Joe