How to cast date "2015-03-03-012204-000000" to timestamp
- 1 Answers
- 3360 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 is the difference between union and union all in teradata?
What is the syntax for case when statement?
1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE? 2)MOST OF THE COMPANIES ARE USING TARA DATA FOR "DWH PROJECTS" ONLY? WHY?
6 Answers Bank Of America, Wipro,
What is the basic syntax for teradata select statement?
Aborted in Phase 2 data acquistion completed in fastload?
What is the primary index in teradata?
Hi Frnds this que is recently asked at IBM there are two rows like aa6588fhfhf,gru282vbvv. Question is howcan we retrive the first number from two rows. Can any one help thanks in advance
What are the functions performed by bynet?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
any one answer me how they can analyzing the project using data ware housing?
What is meant by a Highest Cost Plan?
Explain the meaning of Amp?
Teradata 
