[Firebird-devel] timestamp field

2020-01-10 Thread Evelyne Girard
> In FB4, when adding a timestamp field it creates me timestamp_tz (32752). > normal? > Norbert Saint Georges With 64bits FBserver 4.0.0.1714 on Windows, adding timestamp creates correctly a timestamp without timezone. With which version do you have this result ? Evelyne Firebird-Devel mailin

Re: [Firebird-devel] timestamp field

2020-01-10 Thread Evelyne Girard
> Actually, it shouldn't be this way because explicitly states that "`TIME` > and `TIMESTAMP` are synonymous to theirs respectively `WITHOUT TIME ZONE` > data types". > -- > WBR, SD. So sorry for my error, I will not do that againt (answering based on memory) ... only to find this was stat

Re: [Firebird-devel] timestamp field

2020-01-10 Thread Dimitry Sibiryakov
10.01.2020 23:27, Evelyne Girard wrote: In FB4, when adding a timestamp field it creates me timestamp_tz (32752). normal? Yes, unless you force FB4 to use previous versions default datatypes either with (DataTypeCompatibility = 3.0 in Firebird.conf) or with set bind of timestamp with time zon

[Firebird-devel] timestamp field

2020-01-10 Thread Evelyne Girard
> In FB4, when adding a timestamp field it creates me timestamp_tz (32752). > normal? Yes, unless you force FB4 to use previous versions default datatypes either with (DataTypeCompatibility = 3.0 in Firebird.conf) or with set bind of timestamp with time zone to legacy; (see README.set_bind.md i

[Firebird-devel] timestamp field

2020-01-10 Thread Norbert Saint Georges
Hello In FB4, when adding a timestamp field it creates me timestamp_tz (32752). normal? -- Norbert Saint Georges http://tetrasys.fi Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel