Am Mittwoch, 14. Februar 2007 11:53 schrieb Alban Hertroys: > I think you're looking for this: > > select to_date('01 2004', 'WW YYYY'); > to_date > ------------ > 2004-01-01 > (1 row)
Or possibly to_date('01 2004', 'IW IYYY'), depending on taste. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly