access_time 3 years ago languageEnglish
more_vert

Convert varchar to date in SQL / Teradata

visibility 4,052 comment 0

This code snippet shows how to convert string to date.

In Teradata, CAST function can be used to cast string/varchar to date. Format string can be used. For example, B represents blank/space while YYYY represents years.

Code snippet

SELECT CAST('2017-10-15' AS DATE FORMAT 'YYYY-MM-DD');

SELECT CAST('2017 10 15' AS DATE FORMAT 'YYYYBMMBDD');

SELECT CAST('2017 Oct 15' AS DATE FORMAT 'YYYYBMMMBDD');

SELECT CAST('15, Oct, 2017' AS DATE FORMAT 'DD,BMMM,BYYYY');

-- default ansi format

SELECT CAST('2017-10-15' AS DATE);

-- use to_date function

SELECT to_date('2017-10-15', 'YYYY-MM-DD');
info Last modified by Raymond 2 years ago copyright This page is subject to Site terms.
Like this article?
Share on

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

Follow Kontext

Get our latest updates on LinkedIn.

Want to contribute on Kontext to help others?

Learn more

More from Kontext

visibility 447
thumb_up 0
access_time 6 months ago
visibility 38
thumb_up 0
access_time 5 months ago
visibility 17054
thumb_up 1
access_time 4 years ago