Postgresql likes Tuesday... - Mailing list pgsql-hackers

select to_char(  to_date(    CAST(extract(week from CURRENT_TIMESTAMP) as text)    || CAST(extract(year from
CURRENT_TIMESTAMP)as text)    , 'WWYYYY')  , 'FMDay, D');
 
 to_char   
------------Tuesday, 3
(1 row)


Not that it matters for me at the moment (I care that it's in the week
of..), but why does it pick Tuesday?

--  Rod Taylor