SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Weekday function not working

bd378709-6e9b-4673-b99a-fe68d310197aAug 13 2019 — edited Aug 14 2019

Hi,

Not sure what doing wrong, I'm still new to ORacle- MS SQL background. I'm trying to use the

WeekDay function but it keeps saying that WeekDay is an invalid Identifier.

WeekDay(OR_LOG.Surgery_Date)

The ultimate outcome I want is to be able to put it in a Where clause:

WeekDay(OR_LOG.Surgery_Date) not in (1,7)

Any help would be appreciated. Just trying to eliminate surgeries that were performed on Saturday or Sunday.

Thanks,

Added on Aug 13 2019

8 comments

5,537 views