Hi All:

I have a datetime field in a table becuase there was no option for just a Time field.

Variable mCurTime = time(), which I then use to insert into the table using SQL Insert. The field however is does not have any values in it, but show the spaces for date and time. All I want to do here is to capture the time of day only. Any suggestion?

TIA

Ravi