> 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?
>

"Cor Ligthert" <notfirstname@planet.nl> wrote in message
news:OdqEhMKlEHA.3544@TK2MSFTNGP15.phx.gbl...
> Bryan,
>
> Especially for globalization it is better not to use your kind of code,
>
> In my opinion is better to use something as
> Dim mydate As DateTime = New Date(1900, 1, 1, Now.Hour, Now.Minute,
> Now.Second)
>
> (As far as I know has the datatable no "smalldatetime" only "datetime",
> however when I wrong in that let somebody correct me?).
>
> I hope this helps,
>
> Cor
>
>
> "Bryan"
>
>> 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?
>>
>
>