We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Submitted by: @asfernandes
Firebird date-time parser accepts non-standard separators, accepting (interpreting) wrong strings.
These are currently considered valid:
SQL> select timestamp '2018-01-01 10 20 30' from rdb$database;
CONSTANT
========================= 2018-01-01 10:20:30.0000
SQL> select timestamp '2018-01-01 10,20,30 40' from rdb$database;
========================= 2018-01-01 10:20:30.4000
This is a problem when timezone is introduced, as the zone is separated from the time by a space.
Commits: 53be87c 4812ce8
The text was updated successfully, but these errors were encountered:
Version: 3.0.3 [ 10810 ]
Version: 2.5.8 [ 10809 ]
Version: 4.0 Alpha 1 [ 10731 ]
Component: Engine [ 10000 ]
assignee: Adriano dos Santos Fernandes [ asfernandes ]
Sorry, something went wrong.
Commented by: @asfernandes
Fixed in branch work/time-zone-support.
Date components separator may be a single one (first and second occurence): dash, slash or dot.
Time components (hours to minutes to seconds) separator may be colon.
Seconds to fractions separator may be dot.
There could not be any separator (other than spaces) between date and time.
Spaces are allowed before and after separator characters.
status: Open [ 1 ] => Resolved [ 5 ]
resolution: Fixed [ 1 ]
Fix Version: 4.0 Beta 1 [ 10750 ]
status: Resolved [ 5 ] => Resolved [ 5 ]
QA Status: No test => Done successfully
status: Resolved [ 5 ] => Closed [ 6 ]
asfernandes
No branches or pull requests
Submitted by: @asfernandes
Firebird date-time parser accepts non-standard separators, accepting (interpreting) wrong strings.
These are currently considered valid:
SQL> select timestamp '2018-01-01 10 20 30' from rdb$database;
=========================
2018-01-01 10:20:30.0000
SQL> select timestamp '2018-01-01 10,20,30 40' from rdb$database;
=========================
2018-01-01 10:20:30.4000
This is a problem when timezone is introduced, as the zone is separated from the time by a space.
Commits: 53be87c 4812ce8
The text was updated successfully, but these errors were encountered: