> 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

just cast as date to strip time
Alan