Converting date format SQL using convert()

Question

I have the date in the format of yy-mm-dd and I want to convert it to dd-mm-yyyy. I used the following select statement:

select  convert(varchar(30), hiredate, 110)
from emp;

But, I keep getting an error that there's a missing expression:

ORA-00936: missing expression

Can someone please guide me?

ntalbs · Accepted Answer · 2013-06-17 02:38:13Z

2

If the hiredate's data type is DATE, then use to_char function:

select to_char(hiredate, 'dd-mm-yyyy') from emp;

If the hiredate's data type is VARCHAR2 or CHAR, convert it to DATE by to_date then use to_char:

select to_char(to_date(hiredate, 'yy-mm-dd'), 'dd-mm-yyyy') from emp;

answered Jun 17, 2013 at 2:38

ntalbs

29.6k8 gold badges72 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1