top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to convert the date format 'MM/DD/YY' to 'DD-MMM-YYYY'

+1 vote
2,634 views

I am getting one data filed from one text file at format 'MM/DD/YY'(like '06/13/14'). Now I want to convert it as 'DD-MMM-YYYY' like (13-JUN-2014).

Please help me in this conversion.

posted Jun 18, 2014 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Convert input value to date by using to_char(to_date(in_date, 'mm/dd/yyyy'), 'DD-MON-YYYY')

answer Jun 18, 2014 by Shatark Bajpai
Similar Questions
+2 votes

I am have one date (string) field in the format 'dd-mmm-yy' like ('1-Jan-87'). Now I want to convert it as 'DD/MM/YYYY' like (01/01/1987).

Please help me in this conversion.

+1 vote

Items in dropdown
01/31
02/28
03/31
04/30
.........

12/31

+1 vote

I need to convert a string to a date so I can do a compare with what is in my column. My statement is this:

Decode(IsNew, FALSE, 
  IIF (v_save_view_row_obsolete_day <> 
    TO_DATE('9999-12-31 00:00:00 AM','YYYY-MON-DD HH24:MI:SS'), 
     '9999-12-31 00:00:00', v_save_view_row_obsolete_day))

When I validate I get this error: enter image description here

0 votes

Write a C program to convert date from 24 hrs format to 12 hrd format?
Ex: 23:10 = 11:10PM

...