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

Highlight a few of the important components of Teradata?

1011

What is teradata and why it is used?

1076

Explain and compare pros and cons of start schemas?

1046

What are the different table types supported by teradata?

947

What are the components provided on node?

1024

What are the various indexes in teradata? Why are they preferred?

993

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2152

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

1073

What is multi insert?

1037

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1222

In Teradata, how do we Generate Sequence?

1029

What does Amp contain and what are all the operations that it performs?

992

What is a clique?

1071

List out teradata data types?

998

Explain Teradata performance tuning and optimization?

1148