This thread become full of offtopic discussion... Discussion here is about
date/time separators, for consistency and correct handling of time zone
offsets.
As Firebird accepts everything (spaces, commas, minus, etc) as separators,
that is very problematic to separate the time and timezone offset portions,
as they should be separated by a space followed or not by a minus or plus
sign (the sign is optional) and a number.
Only that. Timezone is another discussion, break in all ways the current
date/time format is also another discussion.
Adriano
Em 28 de fev de 2018 13:42, "Leyne, Sean" <s...@broadviewsoftware.com>
escreveu:
>
>
> > 28.02.2018 16:42, Leyne, Sean wrote:
> > > Based on this, and considering legacy FB applications I propose the
> > following:
> > >
> > > 1- The only acceptable string format for the new Date/Time with
> > > Timezone datatypes should be the ISO/SQL standard
> > >
> > > 2- Only legacy DATE and TIMESTAMP datatype would maintain support for
> > the legacy date formats.
> >
> > Does Firebird parser have a problem with rule '<timezoned value> :=
> > <leagcy
> > timestamp><space><timezone>'?
> > I can't remember example of timezone that would make parsing conflict
> > between time part of timestamp and time zone string.
>
> First, I was referring to input formats which would/should not require a
> CAST, for legacy support purposes.
>
> Second, I don't really care if the parser could support it for the new
> types.
>
> IMO, FB should not need to support date/timestamp legacy formats for new
> data types, expect via explicit CAST to .
>
>
> Sean
>
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
