Skip to content
This repository has been archived by the owner on Dec 3, 2019. It is now read-only.

Timestamp encoding with BC dates #248

Open
cornerman opened this issue May 10, 2018 · 0 comments
Open

Timestamp encoding with BC dates #248

cornerman opened this issue May 10, 2018 · 0 comments

Comments

@cornerman
Copy link

When having a LocalDateTime with a negative year, this is encoded as a date string with a negative year (sign in front of the year number). But this throws an SQL-Error ErrorMessage(fields=Map(Line -> 3793, File -> datetime.c, SQLSTATE -> 22009, Routine -> DateTimeParseError, V -> ERROR, Message -> time zone displacement out of range: "-4713-01-01 00:53:28.000000", Severity -> ERROR)).

For postgres, negative years need to be encoded with a BC postfix after date string instead.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant