Thanks Andrew, this looks like it might well be the solution to my
problem. I'll give it a try later on (when the database is not being
so heavily used.)

Do you happen to know if there is a definitive list of FireBird
functions (like cast, substring etc) available anywhere? I can't find
any form of documentation for FB anywhere.

Steve

--- In ib-support@y..., "csswa" <csswa@y...> wrote:
> --- In ib-support@y..., Helen Borrie <helebor@t...> wrote:
> > >I am looking for something like:
> > >
> > >update table1 set logindate=date(login), loginTime=time
(login) ...
> >
> > update table1 set logindate=CURRENT_DATE,
> > logintime=CURRENT_TIME
> >
>
> update table 1 set
> logindate = cast(login as date),
> logintime = cast(login as time)
>
> although I'm pretty sure you can just do logindate = login for the
> date one (implicit casting). Not sure about doing logintime =
> login... try it and see. If it fails, revert to the casting.
>
> Regards,
> Andrew Ferguson
> -- Where did you want to go today before you ended up here?