Interested to Buy Any Domain ? << Click Here >> for more details...
How to cast date "2015-03-03-012204-000000" to timestamp
- 1 Answers
- 4081 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 |
What does sleep function does in fast load?
What is primary index and secondary index?
Difference between client character set and server character set? What is the use of these two?default character set in teradata?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Highlight the points of differences between the database and user in Teradata.
How to identify ppi columns?
What are the joins in 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?
Explain the meaning of Amp?
TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)
Name the five phases that come under MultiLoad Utility.
What is the purpose of joins in teradata?
Teradata 
