On Thu, 16 Sep 1999, Aaron Scott-Boddendijk wrote:
> is there any reason why you can't do this clientside (like using Data-aware
>datefield)?
> MyDate := Trunc(Q.Fields[0].AsDateTime);
Well I was trying to do it all in SQL, to be used in an INSERT INTO query,
however, I've just noticed that BDE 5.01 has a working CAST operation on
paradox tables, so I'm now using:
INSERT INTO
SomeTable
SELECT DISTINCT
CAST(DateTimeAdded AS DATE) AS GoodDate
Under BDE4 this didn't want to work, but it does now :) Yippee...
--
Mark Derricutt | Chalice of Blood
Software Developer | New Zealand Christian Music News
Auckland, New Zealand | http://www.chalice.gen.nz
[EMAIL PROTECTED] | UIN: 1934853
Getting jiggy with <no audio cd present>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
