At 04:33 PM 2/14/03, [EMAIL PROTECTED] 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');
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
