Hi, I have the following query that works:
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.
Mark
--
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
