On Tue, Feb 18, 2020 at 11:59:58PM -0300, Atila Rangel wrote:
> Hi, I'm a software developer working with Postgresql database. Recently, I
> have had a issue with Week Day queries. Basically, I tried to filter some
> datetime based on day of week name. I'm sending a sql that you can
> reproduce the bug. This may not be a bug. But, I would like to report this.
It's not a bug. It is described in
https://www.postgresql.org/docs/current/functions-formatting.html :
day: full lower case day name (blank-padded to 9 chars)
you most likely want to use to_char(some_date, 'FMday')
depesz