parse_datetime/parse_timestamptz does not parse given valid string

lestrrat-p5 / DateTime-Format-Pg

Other

2 stars 5 forks source link

parse_datetime/parse_timestamptz does not parse given valid string #23

Open mnbv09870987 opened 2 years ago

mnbv09870987 commented 2 years ago

DateTime::Format::Pg->parse_timestamptz( '2021-10-12 09:04:07 EST' )
  ERROR: Invalid date format: 2021-10-12 09:04:07 EST at

Hi. As you can see on the picture above the datetime is parsed by postgresql server successfully, but parsing via module does not work

yewtc commented 1 year ago

The parser converts a pg formatted date to DateTime format. Pg wouldn't naturally specify the time zone as EST, but as +03 as you show so this isn't a problem.