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
