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

What's the difference between timestamp (0) and timestamp (6)?

0 Answers  


What do you mean by teradata intellicloud?

0 Answers  


Explain fallback in teradata?

0 Answers  


what is the difference between primary index and secondary index?.

2 Answers   IBM,


What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .

5 Answers   Accenture,


What's the syntax of sub string?

1 Answers  


can we have an unconnected lkp to lookup a DB2 record against a Teradata record?

3 Answers  


i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me

8 Answers   Satyam,


what is identity columns in teradata

2 Answers   Wipro,


What is oltp?

0 Answers  


I have all the TERADATA Certification Dumps for the below: NR0-011, NR0-012, NR0-013, NR0-014 NR0-015 NR0-016, NR0-017 If anyone need it, pls drop me a mail with Code in the mail to: terashish@gmail.com

201 Answers   Cognizant, Deloitte, IBM, Prometric, Syntel,


Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.

1 Answers  


Categories