Subject Re: DateTime Field Manipulations
Author csswa
--- 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.

Andrew Ferguson
-- Where did you want to go today before you ended up here?