Page 1 of 1

The name of the day through a date function

Posted: Thu Sep 16, 2021 11:42 pm
by 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.

Re: The name of the day through a date function

Posted: Fri Sep 17, 2021 12:00 am
by 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'.

Re: The name of the day through a date function

Posted: Fri Sep 17, 2021 9:56 pm
by Diego Euri Almanzar
Thanks, Skiman.

Best regards.

Re: The name of the day through a date function

Posted: Fri Sep 17, 2021 11:11 pm
by Auge_Ohr
hi,

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

you got Constant NLS_* to configure Display Format

Re: The name of the day through a date function

Posted: Thu Oct 07, 2021 10:49 pm
by Diego Euri Almanzar
Excellent data, very useful, Jimmy.

Best regards.