Try select to_char( '1969-10-22'::date, 'YYYY-MM-DD');
wishy wishy wrote: > > hi folks, > we have a PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC 2.96 > installation on pogo linux 7.2 > we are facing a data problem when we do the following > select to_char(to_date('1969-10-22','YYYY-MM-DD'),'YYYY-MM-DD'); > > ERROR: Unable to convert date to tm > > we have been trying to find a solution for this have you found such > instances before it there a method to over come this. > Any help will be greatly appreciated. > thanks > kris > > _________________________________________________________________ > Get faster connections -- switch to MSN Internet Access! > http://resourcecenter.msn.com/access/plans/default.asp > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])