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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
