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

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

932

What is database exceptions in teradata?

894

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

939

How can bottlenecks be identified?

955

What is a node in teradata?

935

why use references rather than pointers in the public api, particularly for arguments which are modified?

937

Describe primary index in teradata?

957

what is sysdba and sysdbc ? which has high priority ?

3759

Explain the term 'database' related to relational database management system?

929

How can we check the version of Teradata that we are using currently?

1012

In Teradata, how do we Generate Sequence?

981

What is the difference between teradata and oracle?

954

What is a dimension table?

981

Why teradata is used?

940

how can we analyze the locks ?

2058