| From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
|---|---|
| To: | Atila Rangel <atila(dot)rangel(at)cyberlabs(dot)com(dot)br> |
| Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: [Bug Report] Week Day |
| Date: | 2020-02-19 10:47:11 |
| Message-ID: | 20200219104711.GA1797@depesz.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ahsan hadi | 2020-02-19 13:59:21 | Re: DROP OWNED CASCADE vs Temp tables |
| Previous Message | legrand legrand | 2020-02-19 10:11:16 | Re: Partitioning Column needs to be Key |