Skip to content

"SET BIND OF TS WITH TZ TO VARCHAR(128)" uses the date format of dialect 1. #7729

@dmitry-lipetsk

Description

@dmitry-lipetsk

FB 4.0.3.2973, database with dialect 3.

SET BIND OF TIMESTAMP WITH TIME ZONE TO varchar(128);
select timestamp '2023-08-29 01:02:03.0123 +3:0' from rdb$database;

Server returns string "29-AUG-2023 1:02:03.0123 +03:00"

I think. when client uses dialect 3, server should return "2023-08-29 1:02:03.0123 +03:00"


The second problem(?) - server ignores the size of VARCHAR. It returns the string with 57 symbols.

RDB$TIME_ZONES table says that TIME ZONE name can be up to 63 symbols.


image

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions