How to cast date "2015-03-03-012204-000000" to timestamp
- 1 Answers
- 3375 Views
- Cognizant, I also Faced
- E-Mail Answers
Answer / akhil kumar
SELECT TO TIMESTAMP('YYYY-MM-DD-HHMISS-FF')
FROM DUAL;
| Is This Answer Correct ? | 0 Yes | 4 No |
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What are the multiload utility limitations?
We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.
What do you mean by tpt in teradata?
What is the use of upsert command in teradata?
How is Teradata in current market?
What is the difference between SI and JI?
What are the updated features of teradata?
what is the difference between start schma and Fsldm?
How you will check the version of teradata?
sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Teradata 
