Re: datetime to smalldatetime

From: Barak zabari (lotemlotad_at_yahoo.com)
Date: 03/29/05 

Date: Tue, 29 Mar 2005 15:16:43 +0200

You got it backward, as consequence of halving the size of the saved data
they needed to use smaller range of dates.
Since delphi use 8 bits for datetime you can't easly convert to a
smalldatetime.

"P.S.Bell" <pat@patbell.co.uk> wrote in message
news:VA.00000866.00d45b3f@patbell.co.uk...
> 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
>

Relevant Pages

  • Re: Stock price data (open, high, low, close)
    ... > (datetime, open, high, low, close etc) and specifically convert data from ... I searched Torrys and didn't find anything, ... you convert VB or C code to Delphi. ... function CompoundSample(Series: array of TStockMarketSample): ...
    (alt.comp.lang.borland-delphi)
  • Re: Stock price data (open, high, low, close)
    ... > (datetime, open, high, low, close etc) and specifically convert data from ... I searched Torrys and didn't find anything, ... you convert VB or C code to Delphi. ... function CompoundSample(Series: array of TStockMarketSample): ...
    (comp.lang.pascal.delphi.misc)