Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?

You need to apply a format during the cast, either Teradata style:

WHERE CAST(str AS DATE FORMAT 'dd.mm.yyyy') 
BETWEEN DATE '2015-06-01' AND DATE '2017-12-31'

or Oracle style:

WHERE TO_DATE(str, 'dd.mm.yyyy') 
BETWEEN DATE '2015-06-01' AND DATE '2017-12-31'

Btw, I added DATE in front of the string, it’s the recommended (and always reliable) way to write a date literal.

Related Posts:

  1. ORA-01843 not a valid month- Comparing Dates
  2. how to remove time from datetime
  3. Query to convert from datetime to date mysql
  4. How to change post published date to today date with SQL
  5. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  6. SQL WITH clause example [duplicate]
  7. The wait operation timed out. ASP
  8. Conversion failed when converting date and/or time from character string while inserting datetime
  9. how to fix oracle ORA-01722 invalid number error
  10. SQL query to select dates between two dates
  11. MySQL – Operand should contain 1 column(s)
  12. SQL SELECT WHERE field contains words
  13. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  14. NOT IN vs NOT EXISTS
  15. Must declare the scalar variable
  16. How can I do a FULL OUTER JOIN in MySQL?
  17. MySQL query String contains
  18. How do I escape a single quote in SQL Server?
  19. T-SQL split string based on delimiter
  20. Finding duplicate values in a SQL table
  21. MySQL Cannot Add Foreign Key Constraint
  22. Oracle error : ORA-00905: Missing keyword
  23. How do I import an SQL file using the command line in MySQL?
  24. Sql Server equivalent of a COUNTIF aggregate function
  25. Column name or number of supplied values does not match table definition
  26. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  27. Simple PHP Pagination script
  28. Difference between JOIN and INNER JOIN
  29. ORA-12560: TNS:protocol adaptor error
  30. What is the difference between JOIN and UNION?
  31. MySQL Multiple Joins in one query?
  32. “CASE” statement within “WHERE” clause in SQL Server 2008
  33. ORA-00972 identifier is too long alias column name
  34. What is the difference between Scope_Identity(), Identity(), @@Identity, and Ident_Current()?
  35. SQL – HAVING vs. WHERE
  36. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  37. Combining “LIKE” and “IN” for SQL Server
  38. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  39. SQL Server WITH statement
  40. How to SUM two fields within an SQL query
  41. DateTime2 vs DateTime in SQL Server
  42. Difference between numeric, float and decimal in SQL Server
  43. Algebra Relational sql GROUP BY SORT BY ORDER BY
  44. Oracle “Partition By” Keyword
  45. ERROR: there is no unique constraint matching given keys for referenced table “bar”
  46. What is the equivalent of ‘describe table’ in SQL Server?
  47. How do I query for all dates greater than a certain date in SQL Server?
  48. Add a column with a default value to an existing table in SQL Server
  49. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  50. Using group by on multiple columns
  51. What is the purpose of using WHERE 1=1 in SQL statements?
  52. Conversion failed when converting the varchar value ‘simple, ‘ to data type int
  53. postgresql: error duplicate key value violates unique constraint
  54. Is there a workaround for ORA-01795: maximum number of expressions in a list is 1000 error?
  55. How do you force mysql LIKE to be case sensitive?
  56. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  57. What is the difference between a stored procedure and a view?
  58. Bulk load data conversion error (truncation)
  59. Insert into a MySQL table or update if exists
  60. Convert timestamp to date in Oracle SQL
  61. How to order by with union in SQL?
  62. Update statement with inner join on Oracle
  63. Can I use multiple “with”?
  64. PostgreSQL create table if not exists
  65. Incorrect syntax near ”
  66. MySQL: Can’t create table (errno: 150)
  67. Join vs. sub-query
  68. DATEDIFF function in Oracle
  69. GROUP BY and COUNT using ActiveRecord
  70. MySQL – Get row number on select
  71. Arithmetic overflow error converting varchar to data type numeric. ’10’ <= 9.00
  72. Difference between EXISTS and IN in SQL?
  73. What does * mean in sql?
  74. How to truncate the text returned for a column in a MySQL query
  75. How to implement LIMIT with SQL Server? [duplicate]
  76. What’s the best way to dedupe a table?
  77. Moving database with phpMyAdmin
  78. How To Write An Inner Join With WP Query
  79. How do I escape a table name or column name in SQL? esc_sql doesn’t do this
  80. Update user_login, user_nicename, and display_name
  81. Change sticky status of posts from phpMyAdmin
  82. Best Way to Merge a Dev and Live Site to Become a Staging Site?
  83. Needing to move content from postmeta to posts in sql [closed]
  84. How to import a Typo3 database to a wordpress site?
  85. Clean up very big and very dirty database
  86. How to delete ALL comments from certain category in WordPress database?
  87. How can I convert everything from category X to have post format Link
  88. Bulk delete WordPress Post and all metadata, etc using SQL query
  89. What steps do I need to take to install a local copy of a live website?
  90. Reset post IDs with all post meta
  91. How to Add or Change Post Title
  92. Why does DROP TABLE-ing the `wp_options` reset my user session?
  93. How to refactor DB queries for better TTFB in WordPress?
  94. query sql-table and change entities
  95. Duplicate WP Migration affecting site on separate domain?
  96. Analog category_and (WP) in sql query
  97. Backtick (MySQL norm) added to SQL Server Query causing error
  98. SQL query to check whether a meta key is set or not for a post in post_meta table
  99. Firebase with WordPress instead of SQL?
  100. Want to delete woocommerce coupon in bulk from phpmyadmin based on published date

Leave a Comment