SELECT TO TIMESTAMP('YYYY-MM-DD-HHMISS-FF') FROM DUAL;

How to cast date "2015-03-03-012204-000000" to timestamp

Question Posted / akhil kumar

Answer Posted / akhil kumar

SELECT TO TIMESTAMP('YYYY-MM-DD-HHMISS-FF')
FROM DUAL;

Is This Answer Correct ?

0 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is the primary index in teradata?

1286

What are the joins in teradata?

1074

Explain the new features of teradata?

1094

What is meant by a Least Cost Plan?

1109

What is the difference between global temporary tables and volatile temporary tables?

1242

Which is more efficient group by or distinct to find duplicates?

1133

Highlight all the modes that are present under Confidence Level.

1013

How do you create tables? Exact syntax, and create profiles, users in teradata?

1091

In the Primary Index, what is the score of AMPs that are actively involved?

1129

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

1084

Why does varchar occupy 2 extra bytes?

1272

What are types of partition primary index (ppi) in teradata?

1101

What are the functions of a Parser?

1190

What is the use of virtual processor connectivity in teradata?

1094

What is a dimension table?

1104