Raymond
Convert varchar to date in SQL / Teradata
insights Stats
warning Please login first to view stats information.
toc Table of contents
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 5 years ago
copyright
This page is subject to Site terms.
comment Comments
No comments yet.