Subject Re: [ib-support] DateTime Field Manipulations
Author Helen Borrie
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,

NB Dialect 3 only.


All for Open and Open for All
Firebird Open SQL Database · ·