On Apr 19, 2006, at 05:01, Alan McDonald wrote:

> I thought you were trying to avoid UDFs...
> F_TRUNCATE from FreeUDFLib.dll
> select f_truncate(8.657) from rdb$database
> returns 8

The latest incarnation of this library (FreeAdHocUDF) has a whole
pile of date processing functions. The only thing I really wish it
had is some form of strptime.
________________________________________________________
Richard Wesley Software Engineer
Tableau Software
http://www.tableausoftware.com/ hawkfish
tableausoftware com