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



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

Answer / akhil kumar

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

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Teradata Interview Questions

How will you solve the problem that occurs during update?

0 Answers  


What are some primary characteristics of teradata?

0 Answers  


What is the use of virtual processor connectivity in teradata?

0 Answers  


What is the use of having index's on table?

1 Answers  


Diff b/w v2r5 and v2r6 ?

3 Answers   TCS,






How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

0 Answers  


What is meant by Teradata Gateway?

0 Answers  


Highlight all the modes that are present under Confidence Level.

0 Answers  


Syntax for case when statement?

0 Answers  


Fast Load Script is failed and error tables are available then how do you restart?

3 Answers   TCS,


What is spool space? Why do you get spool space errors?

0 Answers  


which option is used to restart the fastexport script ?

2 Answers   TCS,


Categories