> SELECT DISTINCT EXTRACT (DAY FROM GoodDate) FROM CalculatedDates
> But I don't jus want the DAY (i.e. it returns 1, 2, 3, 4) but I want the
> DATE portion of a TimeStamp field, does anyone know how I could do this?
> I know I can provide EXTRACT with MONTH, DAY, and YEAR, but can I get just
> the DATE out of it? (using DATE doesn't work). This is against a
> paradox table.
is there any reason why you can't do this clientside (like using Data-aware
datefield)?
EG
MyDate := Trunc(Q.Fields[0].AsDateTime);
Perhaps a similar truncation can be performed at the database end...
--
Aaron Scott-Boddendijk
Jump Productions
(07) 838-3371 Voice
(07) 838-3372 Fax
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
