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