Release Notes
- 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
- Integrate with StarRocks
- Authenticate to AWS resources

Edit

year

description

Syntax

INT YEAR(DATETIME date)

This function returns the year part in date type (a number from 1000 to 9999).

The parameter is in Date or Datetime type.

example

MySQL > select year('1987-01-01');
+-----------------------------+
| year('1987-01-01 00:00:00') |
+-----------------------------+
|                        1987 |
+-----------------------------+

keyword

YEAR

Edit

In this article

year