SEO

#1 (**permalink**) 04-09-2008, 11:13 PM

LOLL2=# SELECT to_char('2007-12-31':

ATE, 'YYYYIW');
to_char
---------
200701
(1 row)

2007-12-31 should be week 2008-01

regards,

Daniel.

#2 (**permalink**) 04-09-2008, 11:13 PM

BTW:

Windows 2003 Server.

LOLL2=# SELECT version();

version
--------------------------------------------------------------------------------
PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
3.4.2 (mingw-special)
(1 row)

Regards

Daniel Schuchardt schrieb:
> LOLL2=# SELECT to_char('2007-12-31':

ATE, 'YYYYIW');
> to_char
> ---------
> 200701
> (1 row)
>
>
> 2007-12-31 should be week 2008-01
>
> regards,
>
> Daniel.

#3 (**permalink**) 04-09-2008, 11:13 PM

Daniel Schuchardt <daniel_schuchardt@web.de> writes:
> LOLL2=# SELECT to_char('2007-12-31':

ATE, 'YYYYIW');
> to_char
> ---------
> 200701
> (1 row)

> 2007-12-31 should be week 2008-01

No, it shouldn't. YYYY is defined to deliver calendar year.
For ISO year use IYYY.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

bug with >to_char('2007-12-31'::DATE, 'YYYYIW')<