Hi,

 

as this is forwarded to FB3 i ask on support group not devel.

 

Now we have CURRENT_TIME, CURRENT_TIMESTAMP which get time from server whitout timezone.

Why you breake backward compatibility in FB4 (FB3 is still ok)?

 

In FB4 "old" FB3 identifiers

CURRENT_TIME will be LOCAL_TIME

CURRENT_TIMESTAMP will be LOCAL_TIMESTAMP

 

and

 

CURRENT_TIME will became time with timezone

CURRENT_TIMESTAMP will became timestamp with timezone

 

the questions:

1. 

Can i ask why LOCALTIME and LOCALTIMESTAMP was introduced?

Why CURRENT_TIME and CURRENT_TIMESTAMP it is not left the old way?

Why not introduce new ones like e.g. CURRENT_TIME_TZ and CURRENT_TIMESTAMP_TZ to support time zones?

 

2.

If there is real need for identifiers like LOCALTIME and LOCALTIMESTAMP