Subject: RE: Date conversion question 2007-10-03 - By Bobak, Mark
Back
Ok, this shouldn't be too difficult. I'm not going to give you the complete
answer, but here's a good start:
Here's the setup, using your test data:
SQL> create table date_conv(input_date number(6), ora_date date);
Table created.
SQL> insert into date_conv values(991123,null);
1 row created.
SQL> insert into date_conv values(421,null);
1 row created.
SQL> insert into date_conv values(60823,null);
1 row created.
SQL> insert into date_conv values(0,null);
1 row created.
SQL> insert into date_conv values(70930,null);
1 row created.
SQL> commit;
Commit complete.
Ok, now, check it out, this looks like the input data:
SQL> select * from date_conv;
INPUT_DATE ORA_DATE
-- ---- -- -- ------
991123
421
60823
0
70930
|
|
