ORA-00923: FROM keyword not found where expected for select to_char(to_date('03/09/1982','dd/mm/yyyy'), 'DY')

Question

I tried to implement

select to_char(to_date('03/09/1982','dd/mm/yyyy'), 'DY')

but its showing me

ORA-00923: FROM keyword not found where expected.

I am working on oracle 10g express edition.

Do you want to assign the result into a variable? – René Nyffenegger Mar 29 '16 at 05:13 — René Nyffenegger, Mar 29 '16 at 05:13

score 4 · Accepted Answer · answered Mar 29 '16 at 04:46

4

In Oracle, there is no SELECT without FROM. You can use the dual table for this purpose:

SELECT TO_CHAR(TO_DATE('03/09/1982','dd/mm/yyyy'), 'DY')
FROM dual

answered Mar 29 '16 at 04:46

Tim Biegeleisen

1 Answers1