Thanks. That seems a better way to go. At 03:47 PM 4/3/02 -0800, Stephan Szabo wrote:
>On Wed, 3 Apr 2002, Chris Pesko wrote: > > > Never mind. Just figured it out. Need to grab the substring from 2 for 8 > > from the to_char result because it holds character number 1 reserv ed for + > > or - signs. + is default or white space. I think that is the reason. Any > > other input????? > >You might want to try the FM format on the to_char string... >sszabo=# select to_date(to_char(20020101, 'FM99999999'),'yyyymmdd'); > to_date >------------ > 2002-01-01 >(1 row) ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
