DayOfWeek SQL function

[laurarana]

Hi,

I know that the "DayOfWeek" function exists in SQL. But if I make a query in the PL/SQL Developer SQL Window using this function, I encounter an error: "ORA-00904: invalid column name". Is it possible that PL/SQL Developer does not support this kind of function? In this case, how can I obtain the day of week for a date in a table?

Thanks in advance,

LAURA

 

[Clouds]

'DayOfWeek' is not found in the Oracle HTML Tutorials

I think you mean
SELECT to_char(SYSDATE,'DAY') FROM dual
or
SELECT to_char(SYSDATE,'D') FROM dual

HTH

------------------
Clouds

 

[laurarana]

I will try your solution. Thanks a lot.

LAURA