The name of the day through a date function

[Diego Euri Almanzar]

Hi!

How do I get the name of the day through a date function?

I have 7 tables to store employee hours per day. Table 1 is for Monday, Table 2 is for Tuesday, etc. I want to replace the punch clocks.
For that, I have to get a function that returns the name of the day. For example: Friday, September 17, 2021

I need help.

[skiman]

Hi,

CDow( <dDate> ) --> cNameOfDay

When you search for DAY in the help, and then click on 'see also' you get all the functions that are related to day, and you can click on 'Date functions'.

[Diego Euri Almanzar]

Thanks, Skiman.

Best regards.

[Auge_Ohr]

hi,

for DATE() / TIME() Function read also about SetLocale()

you got Constant NLS_* to configure Display Format

[Diego Euri Almanzar]

Excellent data, very useful, Jimmy.

Best regards.