Bert,

Check out: http://www.ibphoenix.com/a600.htm. Also, a google for "SQL-92 Extract" might add insight ...

Essentially, it allows you to pull out individual componets of a DATE or TIME field.

Enjoy,

Eddie Bush

----- Original Message -----
From: bertchughes
To: firebird-support@yahoogroups.com
Sent: Saturday, March 06, 2004 3:05 PM
Subject: [firebird-support] Looking for undocumented function


EXTRACT is listed as a keyword .... but I haven't found any
documentation for it. What does it do?

Thanks,
Bert Hughes


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.611 / Virus Database: 391 - Release Date: 3/4/2004

[Non-text portions of this message have been removed]