Spark SQL - Convert String to Date
articleArticles 578
imageDiagrams 58
commentComments 304
loyaltyKontext Points 6374
more_vert
In Spark, function to_date can be used to convert string to date. This function is available since Spark 1.5.0.
Code snippet
SELECT to_date('2020-10-23', 'yyyy-MM-dd');
SELECT to_date('23Oct2020', 'ddMMMyyyy');Datetime patterns
Refer to the official documentation about all the datetime patterns.
https://spark.apache.org/docs/latest/sql-ref-datetime-pattern.html
| Symbol | Meaning | Presentation | Examples |
|---|---|---|---|
| G | era | text | AD; Anno Domini |
| y | year | year | 2020; 20 |
| D | day-of-year | number(3) | 189 |
| M/L | month-of-year | month | 7; 07; Jul; July |
| d | day-of-month | number(3) | 28 |
| Q/q | quarter-of-year | number/text | 3; 03; Q3; 3rd quarter |
| E | day-of-week | text | Tue; Tuesday |
| F | aligned day of week in month | number(1) | 3 |
| a | am-pm-of-day | am-pm | PM |
| h | clock-hour-of-am-pm (1-12) | number(2) | 12 |
| K | hour-of-am-pm (0-11) | number(2) | 0 |
| k | clock-hour-of-day (1-24) | number(2) | 0 |
| H | hour-of-day (0-23) | number(2) | 0 |
| m | minute-of-hour | number(2) | 30 |
| s | second-of-minute | number(2) | 55 |
| S | fraction-of-second | fraction | 978 |
| V | time-zone ID | zone-id | America/Los_Angeles; Z; -08:30 |
| z | time-zone name | zone-name | Pacific Standard Time; PST |
| O | localized zone-offset | offset-O | GMT+8; GMT+08:00; UTC-08:00; |
| X | zone-offset ‘Z’ for zero | offset-X | Z; -08; -0830; -08:30; -083015; -08:30:15; |
| x | zone-offset | offset-x | +0000; -08; -0830; -08:30; -083015; -08:30:15; |
| Z | zone-offset | offset-Z | +0000; -0800; -08:00; |
| ‘ | escape for text | delimiter | |
| ’‘ | single quote | literal | ’ |
| [ | optional section start | ||
| ] | optional section end |
info Last modified by Raymond 3 years ago
copyright
This page is subject to Site terms.
comment Comments
No comments yet.