I will try -IW
On Fri, Nov 5, 2010 at 1:28 AM, Alexander Farber
wrote:
> But is there a format code for a week starting on Sunday or Monday?
>
> Sorry, I can't find it at
> http://www.postgresql.org/docs/8.4/interactive/functions-formatting.html
--
Sent via pgsql-general mailing list (pgsql
On Fri, Nov 5, 2010 at 1:21 AM, Tom Lane wrote:
> WW is defined as starting the first week on the first day of the year.
> 2010 started on a Friday so the week number increments on Fridays.
>
> There are some other format codes with different behavior ...
Thank you, that is what I thought
But is
Alexander Farber writes:
> sorry for the stupid question, but why has the week number changed
> from 44 to 45 this night?
WW is defined as starting the first week on the first day of the year.
2010 started on a Friday so the week number increments on Fridays.
There are some other format codes wi
Hello,
sorry for the stupid question, but why has the week number changed
from 44 to 45 this night? It is Friday, 2010-11-05 01:10, but I get now:
pref=> SELECT to_char(current_timestamp, '-WW');
to_char
-
2010-45
(1 row)
pref=> SELECT CURRENT_DATE;
date
2010-11-0
