SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

(Neno Second) Date and Time Format (URGENT)

272401Jul 17 2002

With the name of ALLAH,
Dear group fellows,
I have to pickup text data into date field. The data is as under

1707200214153090

First Two digits = Day (DD)
3rd and 4th digits = Month (MM)
5th,6th,7th and 8th digits = Year (YYYY)
9th and 10th digits = Hours (HH)
11th and 12th digits = Minutes (MM)
13th and 14th digits = Seconds (SS)
15th and 16th digits = Neno Seconds (NS)

Now I want to enter the whole string into a field of date datatype. I do not have problem entering upto Seconds, but I do not know how to enter neno seconds into the field. Plz tell me if it is possible to enter neno secons into date datatype field or not? If possible then how? Plz help, its urgent...

Best Regards
Faisal Rafique.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 14 2002

Added on Jul 17 2002

3 comments

559 views