Bismillahir Rahmanir Raheem
Suppose I have table Entry as
Create table Entry(Entered number);
insert into Entry values(12122012);
insert into Entry values(10102013);
insert into Entry values(11112013);
select * from Entry;
Now lets change it to some meaningful way , lets change it to date which it actually represents
SELECT ENTERED,TO_DATE(ENTERED,'DDMMYYYY')
FROM ENTRY;
Suppose I have table Entry as
Create table Entry(Entered number);
insert into Entry values(12122012);
insert into Entry values(10102013);
insert into Entry values(11112013);
select * from Entry;
Now lets change it to some meaningful way , lets change it to date which it actually represents
SELECT ENTERED,TO_DATE(ENTERED,'DDMMYYYY')
FROM ENTRY;
No comments:
Post a Comment