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/
_______________________________________________________