Introduction
Quick Start
Table Design
Data Loading
Data Export
Using StarRocks
Reference
- SQL Reference
  - User Account Management
    - ALTER USER
    - CREATE ROLE
    - CREATE USER
    - DROP ROLE
    - DROP USER
    - GRANT
    - REVOKE
    - SET PASSWORD
    - SET PROPERTY
    - SHOW GRANTS
  - Cluster Management
  - DDL
  - DML
  - Data Types
    - Numeric
      - BIGINT
      - LARGEINT
      - SMALLINT
      - TINYINT
      - BOOLEAN
      - DECIMAL
      - DOUBLE
      - FLOAT
      - INT
    - String
      - CHAR
      - VARCHAR
      - STRING
    - Date
      - DATE
      - DATETIME
    - Others
      - HLL
      - BITMAP
      - JSON
  - Auxiliary Commands
    - DESCRIBE
- Function Reference
  - Date Functions
    - convert_tz
    - curdate
    - current_timestamp
    - curtime
    - datediff
    - date_add
    - date_format
    - date_sub
    - date_trunc
    - day
    - dayname
    - dayofmonth
    - dayofweek
    - dayofyear
    - from_days
    - from_unixtime
    - hour
    - minute
    - month
    - monthname
    - now
    - second
    - str_to_date
    - timediff
    - timestampadd
    - timestampdiff
    - to_date
    - to_days
    - unix_timestamp
    - utc_timestamp
    - weekofyear
    - year
  - Geographic Functions
  - String Functions
    - append_trailing_char_if_absent
    - ascii
    - char_length
    - concat
    - concat_ws
    - ends_with
    - find_in_set
    - get_json_double
    - get_json_int
    - get_json_string
    - group_concat
    - instr
    - lcase
    - left
    - length
    - locate
    - lower
    - lpad
    - ltrim
    - money_format
    - null_or_empty
    - regexp_extract
    - regexp_replace
    - repeat
    - reverse
    - right
    - rpad
    - split
    - split_part
    - starts_with
    - strleft
    - strright
  - JSON Functions
    - Overview of JSON functions and operators
    - JSON constructor functions
    - JSON query and processing functions
    - JSON operators
  - Aggregate Functions
    - any_value
    - approx_count_distinct
    - avg
    - bitmap
    - count
    - hll_union_agg
    - max
    - min
    - percentile_approx
    - retention
    - stddev
    - stddev_samp
    - sum
    - variance
    - square
    - var_samp
  - Bitmap Functions
  - Array Functions
  - cast function
  - hash function
  - Cryptographic Functions
    - md5
    - sha2
  - Math Functions
    - RAND
    - square
- System Variables
- Error Code
- System Limit
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
- Deploy
- Data Migration
  - Data Ingestion
  - Data Export
- SQL
- Other FAQs
Benchmark
- SSB Benchmark
- TPC-H Benchmark
Release Notes
- v2.2
- v2.1
- v2.0
- v1.19

str_to_date

description

Syntax

DATETIME STR_TO_DATE(VARCHAR str, VARCHAR format)

Convert str to DATE type according to the specified format. If the converted result is wrong, NULL will be returned.

Supported format should be consistent with date_format.

example

MySQL > select str_to_date('2014-12-21 12:34:56', '%Y-%m-%d %H:%i:%s');
+---------------------------------------------------------+
| str_to_date('2014-12-21 12:34:56', '%Y-%m-%d %H:%i:%s') |
+---------------------------------------------------------+
| 2014-12-21 12:34:56                                     |
+---------------------------------------------------------+

MySQL > select str_to_date('2014-12-21 12:34:56', '%Y-%m-%d %H:%i:%s');
+--------------------------------------------------------------+
| str_to_date('2014-12-21 12:34%3A56', '%Y-%m-%d %H:%i:%s') |
+--------------------------------------------------------------+
| 2014-12-21 12:34:56                                          |
+--------------------------------------------------------------+

MySQL > select str_to_date('200442 Monday', '%X%V %W');
+-----------------------------------------+
| str_to_date('200442 Monday', '%X%V %W') |
+-----------------------------------------+
| 2004-10-18                              |
+-----------------------------------------+

keyword

STR_TO_DATE,STR,TO,DATE

In this article

str_to_date