Skip to content

Instantly share code, notes, and snippets.

@ateneva

ateneva/SQL_convert_string_to_a_date.sql

Created November 8, 2017 10:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ateneva/ae2117f1cbfe4aff54fa5a05abea2e86 to your computer and use it in GitHub Desktop.
Save ateneva/ae2117f1cbfe4aff54fa5a05abea2e86 to your computer and use it in GitHub Desktop.
Download ZIP
How do I convert string to a date with SQL?
Raw
SQL_convert_string_to_a_date.sql
-----------------------Vertica--------------------------------
select
'2017-03-31' as TextField,
to_date('2017-03-31', 'YYYY-MM-DD') as Datefield
-----------------------PostgreSQL----------------------------
select
'2017-03-31' as TextField,
to_date('2017-03-31', 'YYYY-MM-DD') as Datefield
------------------------MySQL---------------------------------
select
'2017-03-31' as TextField,
str_to_date('2017-03-31', '%Y-%m-%d') as DateField
-----------------------SQL Server-----------------------------
select
'2017-03-31' as TextField,
convert(date, '2017-03-31') as DateField1,
cast('2017-03-31' as date) as DateField2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment