How to cast date "2015-03-03-012204-000000" to timestamp
Answer / akhil kumar
SELECT TO TIMESTAMP('YYYY-MM-DD-HHMISS-FF')
FROM DUAL;
| Is This Answer Correct ? | 0 Yes | 4 No |
what is object level locking ? where do appear this type of locking ?
What are tpump utility limitations?
What do you mean by caching in teradata?
What is FILLER command in Teradata?
what is the query for retrieve the unique values(not display the duplicates values) from single table?
Can we Suggest as how is the process to get a job in teradata in current market??Is it easier???
What is collect State in Teradata ? what it use and how it works??
how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
What are the functions of a teradata dba?
i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80
Can you connect multiload from ab initio?
Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 million records.4th column is empty,Now I have got 5 million records data which has to be loaded into 4th column.How can I load this data fastly in to the 4th column with out using update