[FLINK-6895] Add STR_TO_DATE supported in SQL

• Type: Sub-task
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.4.0
• Component/s: Table SQL / API
• Labels: auto-unassigned pull-request-available
• Assignee: Unassigned
• Reporter: sunjincheng
• Created: 12/Jun/17 09:06
• Updated: 18/Mar/22 14:44

Description

STR_TO_DATE(str,format) This is the inverse of the DATE_FORMAT() function. It takes a string str and a format string format. STR_TO_DATE() returns a DATETIME value if the format string contains both date and time parts, or a DATE or TIME value if the string contains only date or time parts. If the date, time, or datetime value extracted from str is illegal, STR_TO_DATE() returns NULL and produces a warning.

• Syntax:
  STR_TO_DATE(str,format)

• Arguments
  **str: -
  **format: -

• Return Types
  DATAETIME/DATE/TIME

• Example:
  STR_TO_DATE('01,5,2013','%d,%m,%Y') -> '2013-05-01'
  SELECT STR_TO_DATE('a09:30:17','a%h:%i:%s') -> '09:30:17'

• See more:
  • MySQL

Issue Links

• blocks: FLINK-6976 Add STR_TO_DATE supported in TableAPI
• blocks: FLINK-9864 Make timestamp extraction more flexible in SQL Client
• is blocked by: FLINK-7036 Type cast in ExpressionReducer's reduce broke CodeGen's compile stage
• links to: GitHub Pull Request #6359
• links to: GitHub Pull Request #6359