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 inner join and outer join?

1120

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2194

Explain some differences between mpp and smp?

1112

Which is faster fastload or multiload?

1129

What is a level of granularity of a fact table?

1163

While creating table my dba has fallback or no fallback in his ddl. What is that?

1193

What is the purpose of upsert command?

1186

What are the joins in teradata?

1024

What is difference between user and database in teradata?

1079

Explain and compare pros and cons of snow flake schemas?

1037

How do you verify a complicated sql?

1074

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1961

What is bteq script in teradata?

1163

What are the primary characteristics of the Teradata.

1167

What is multi insert?

1061