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

Why teradata is used?

956

What is spool space?

1100

What is a three-tier data warehouse?

1071

Syntax for case when statement?

1023

What is called partitioned primary index (ppi)?

977

What are the steps involved after the disk manager passes the request?

1059

How to view every column and the columns contained in indexes in teradata?

1002

Highlight the points of differences between the database and user in Teradata.

1062

What is a node in teradata?

958

What is meant by Teradata Gateway?

1028

What is smp and mpp platforms?

928

How many codd's rules are satisfied by teradata database?

1067

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

1142

How do you determine the number of sessions?

1025

What is TPD?

1329