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

1 Answers
4233 Views
Cognizant, I also Faced
E-Mail Answers

Answer Posted / akhil kumar

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

Is This Answer Correct ?

0 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a level of granularity of a fact table?

1158

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1171

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

1007

Steps to create a data model?

1135

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1109

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2867

What is the function of parser component in teradata?

1087

Explain BYNET.

1005

What tools would you use for that?

1109

Highlight a few of the advantages that ETL tools have over Teradata.

1090

What is meant by a Channel Driver?

1249

Explain and compare pros and cons of start schemas?

1066

What is the purpose of upsert command?

1177

What is a node in teradata?

999

What is meant by Teradata Gateway?

1058