Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
Data types and expressionsThese topics describe the data types and expressions that HCL OneDB™supports.
Expression
Function Expressions
Time FunctionsThe time functions of HCL OneDB™ accept DATE or DATETIME arguments, or character representation of a DATE or DATETIME value. They typically return DATE or DATETIME values, or convert information that they extract from DATE or DATETIME values into character strings or integers.
WEEKDAY FunctionThe WEEKDAY function accepts a DATE or DATETIME argument, and returns an integer in the range from 0 to 6 that represents the day of the week.

WEEKDAY Function

The WEEKDAY function accepts a DATE or DATETIME argument, and returns an integer in the range from 0 to 6 that represents the day of the week.

As the return value, zero (0) represents Sunday, one (1) represents Monday, and so on.

The following query returns all the orders that were paid on the same day of the week as the current date:

SELECT * FROM orders
   WHERE WEEKDAY(paid_date) = WEEKDAY(CURRENT);

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.