Release Notes
- v3.0
- v2.5
- v2.4
- v2.3
- v2.2
- v2.1
- v2.0
- v1.19

Introduction
Quick Start
Table Design
Data Loading
Data Export
Using StarRocks
Reference
- SQL Reference
- Function Reference
  - Date Functions
  - Geographic Functions
  - String Functions
  - Aggregation Functions
  - Bitmap Functions
  - Array Functions
  - cast function
  - hash function
  - Crytographic Functions
    - md5
    - sha2
  - Math Functions
    - RAND
    - square
  - Utility Functions
    - uuid
    - uuid_numeric
- System variables
- Error code
- System limits
Administration
- Build in Docker
- Manage a cluster
- Configuration
- Scale In and Out
- Backup and Restore
- Data Recovery
  - Data Recovery
  - Restore FEs
- Replica
- Query Planning
- Profiling
- Monitor and Alert
- User Privilege
- Authentication
- Resource Management
FAQ
- Deployment
- Data Migration
  - Data Ingestion
  - Data Export
- SQL
- Others FAQs
Benchmark
- SSB Benchmark
- TPC-H Benchmark

Developers
- Contribute to StarRocks
- Code Style Guides
  - protobuf style guides
  - thrift style guides
- Use the debuginfo file for debugging
- Development Environment
- Trace Tools
  - Trace
Integration

Edit

dayofweek

description

Syntax

INT dayofweek(DATETIME date)

DAYOFWEEK function returns the weekday index for a given date. (e.g. Monday: 1, Tuesday: 2, Saturday: 7)

The parameter is Date or Datetime type. It can also be casted as numbers in Date or Datetime type.

example

MySQL > select dayofweek('2019-06-25');
+----------------------------------+
| dayofweek('2019-06-25 00:00:00') |
+----------------------------------+
|                                3 |
+----------------------------------+

MySQL > select dayofweek(cast(20190625 as date));
+-----------------------------------+
| dayofweek(CAST(20190625 AS DATE)) |
+-----------------------------------+
|                                 3 |
+-----------------------------------+

keyword

DAYOFWEEK

Edit

In this article

dayofweek