NO .. obviously I wasn't clear. The existing field information is
historic, not current. Dates in the field go back up to 18 months.

--- In ib-support@y..., Helen Borrie <helebor@t...> wrote:
> At 01:19 PM 13-05-02 +0000, you wrote:
> >I have a table (Firebird) with two fields (login and logout) both
> >currently defined as DateTime fields. For various reasons I now
need
> >to split each of these fields into 2 separate fields (one
containing
> >the date portion and the other the time). Under MySQL I could do a
> >simple update query using functions to separate out the two
elements
> >of the existing field. How do I achieve this under Firebird?
> >
> >I am looking for something like:
> >
> >update table1 set logindate=date(login), loginTime=time(login) ...
>
> update table1 set logindate=CURRENT_DATE,
> logintime=CURRENT_TIME
>
> NB Dialect 3 only.
>
> Helen
>
> All for Open and Open for All
> Firebird Open SQL Database · http://firebirdsql.org ·
> http://users.tpg.com.au/helebor/
> _______________________________________________________