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 are the different table types that are supported by teradata?

542

What are different table types used in teradata?

590

What is the difference between teradata and basic rdbms?

570

What is the function of parser component in teradata?

621

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

2910

What do you mean by caching in teradata?

611

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

604

Different phases of multiload?

596

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

1508

What is meant by a Highest Cost Plan?

628

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

560

Which is faster fastload or multiload?

600

What is a node in teradata? Explain

605

What is called partitioned primary index (ppi)?

569

What are the main components of teradata system?

585