<br /><font face="sans-serif" size="2">When I run </font><font color="blue" face="MS Sans Serif"
size="1">select</font><fontface="MS Sans Serif" size="1"> to_date('20030212','YYYYMMDD') the output is
2/12/03</font><br/><font face="MS Sans Serif" size="1">if I run </font><font color="blue" face="MS Sans Serif"
size="1">select</font><fontface="MS Sans Serif" size="1"> to_date( to_char(20030212,99999999),'YYYYMMDD'); the output
is6/23/05</font><br /><br /><font face="MS Sans Serif" size="1">How can I convert from integer into date format
correctly?</font><br/><br /><font face="MS Sans Serif" size="1">Thanks for any help with this.</font><br /><br /><font
face="MSSans Serif" size="1">Svetlana</font><br /><br /><font color="#000000" face="Helv" size="3"></font><br /><font
color="#000000"face="Helv" size="3"></font><br /><font color="#000000" face="Helv" size="3"></font><br /><font
color="#000000"face="Helv" size="3">Jefferies archives and reviews outgoing and incoming e-mail. It may be produced at
therequest of regulators or in connection with civil litigation. Jefferies accepts no liability for any errors or
omissionsarising as a result of transmission. Use by other than intended recipients is prohibited.</font><br />