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!

String column with some date formats to date

971441Oct 30 2012 — edited Oct 30 2012

Hi!
Im new in Oracle :)
I need to convert a string column {VARCHAR2 (70 Byte)} to date. But this column have some type os dates... I found three types:

17/02/12 06:00:04,403398 -02:00
19-MAR-12 06.00.07.936287 AM -03:00
30/03/2012 06:00:03:000

How can I convert this column to date? I dont need hours, just the date...
Im using Oracle 10g.

Thanks a lot!

This post has been answered by TPD-Opitz on Oct 30 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 27 2012

Added on Oct 30 2012

#date, #multiple

14 comments

446 views