How to cast date "2015-03-03-012204-000000" to timestamp
- 1 Answers
- 3382 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 you eliminate duplicates?
Explain teradata utilities?
can we load 10 millions of records into target table by using tpump?
Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.
How do you verify a complicated sql?
what is the structure of UV table in MLOAD?
What are the main components of teradata system?
What is collect State in Teradata ? what it use and how it works??
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me
What is the use of teradata system software?
why use references rather than pointers in the public api, particularly for arguments which are modified?
How do you design aggregate tables using teradata?
Teradata 
