Re: convert from an integer to a date

At 04:33 PM 2/14/03, STashlitsky@JEFCO.com wrote:
>When I run select to_date('20030212','YYYYMMDD') the output is 2/12/03
>if I run select to_date( to_char(20030212,99999999),'YYYYMMDD'); the 
>output is 6/23/05
>
>How can I convert from integer into date format correctly?


Same as the first one, except leave out the quotes.        select to_date(20030212,'YYYYMMDD');