Conversion

STR_TO_DATE

MySQL

Mengkonversi string ke DATE, DATETIME, atau TIME berdasarkan format yang diberikan. Kebalikan dari DATE_FORMAT.

Tipe hasil: DATE | DATETIME | TIMEDiperbarui: 7 Jan 2026

Syntax

SQL

STR_TO_DATE(str, format)

strVARCHARwajib

String tanggal/waktu yang akan dikonversi

formatVARCHARwajib

Format string (%Y, %m, %d, dll)

SQL

1 SELECT STR_TO_DATE('15-01-2024', '%d-%m-%Y') AS date_val;

Parse format DD-MM-YYYY.

Hasil

date_val: 2024-01-15

SQL

1 SELECT STR_TO_DATE('2024-01-15 14:30:00', '%Y-%m-%d %H:%i:%s') AS dt;

Parse format YYYY-MM-DD HH:MM:SS.

Hasil

dt: 2024-01-15 14:30:00

SQL

1 INSERT INTO events (event_date)
2 SELECT STR_TO_DATE(date_string, '%M %d, %Y')
3 FROM import_data;

Parse 'January 15, 2024' format.

Hasil

(dates parsed and inserted)

TO_DATE

PostgreSQL

TO_DATE

Snowflake

PARSE_DATE

BigQuery

STRPTIME

DuckDB

1	INSERT INTO events (event_date)
2	SELECT STR_TO_DATE(date_string, '%M %d, %Y')
3	FROM import_data;