What about using cast and casting it as a date?
-----Original Message-----
From: Mark Derricutt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 16 September 1999 11:54
To: Multiple recipients of list database
Subject: [DUG-DB]: extract sql statements
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
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
