How to cast date "2015-03-03-012204-000000" to timestamp

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

How do you verify a complicated sql?

623


What is primary index and secondary index?

567


How many tables can you join in v2r5?

619


What is the purpose of joins in teradata and what are the available join types?

540


What is collect statistics?

585






What do you mean by fastexport in teradata?

555


What do you mean by teradata intelliflex?

624


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

609


What is meant by a node?

615


How to identify ppi columns?

651


What is called partitioned primary index (ppi)?

557


What is dimensional modeling?

589


What is TPD?

900


How can you track login parameters of users in teradata?

630


Can we collect statistics on multiple columns?

563