query to return specific date from teradata timestamp(6)

sql teradata
RRR picture RRR · Oct 22, 2013 · Viewed 43.3k times · Source

How can i search for a particular date for eg: '2013-10-22' from teradata timestamp(6) field?

sel * from table A
where date = '2013-10-22';

I tried the above query which is throwing error. Please help!

Answer

Rahul Tripathi picture Rahul Tripathi · Oct 22, 2013

You may try like this:-

sel * from table A
where date = date '2013-10-22';

Since in ANSI standard form (must be preceded by the keyword DATE)

Check out this

Related questions

SQL SELECT multi-columns INTO multi-variable

I'm converting SQL from Teradata to SQL Server in Teradata, they have the format SELECT col1, col2 FROM table1 INTO @variable1, @variable2 In SQL Server, I found SET @variable1 = ( SELECT col1 FROM table1 ); That only allows a single column/variable …

Read More
What is ROWS UNBOUNDED PRECEDING used for in Teradata?

I am just starting on Teradata and I have come across an Ordered Analytical Function called "Rows unbounded preceding" in Teradata. I tried several sites to learn about the function but all of them uses a complicated example explaining the …

Read More
Find which rows have different values for a given column in Teradata SQL

I am trying to compare two addresses from the same ID to see whether they match. For example: Id Adress Code Address 1 1 123 Main 1 2 123 Main 2 1 456 Wall 2 2 456 Wall 3 1 789 Right 3 2 100 Left I'm just trying to figure out whether the address for each ID …

Read More