datetime to smalldatetime

From: P.S.Bell (pat_at_patbell.co.uk)
Date: 03/29/05


Date: Tue, 29 Mar 2005 12:33:40 +0100

I have been told in this newsgroup that it is not possible to
convert a Delphi datetime to SQL Server smalldatetime.

So my only solution to sending datetimes from delphi to SQL
Server is to change any SQL Server smalldatetime fields to
datetimes?

Considering that the difference is simply range (albeit as a
consequence of narrowing the range the actual size halves to 4
bits) - I find this surprising.

Pat Bell