Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How to cast date "2015-03-03-012204-000000" to timestamp



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

Post New Answer

More Teradata Interview Questions

How to view every column and the columns contained in indexes in teradata?

0 Answers  


In general, how do you optimze any sql in teradata?

0 Answers  


Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M

6 Answers   JPMorgan Chase,


What is the difference between global temporary tables and volatile temporary tables?

0 Answers  


How to cast date "2015-03-03-012204-000000" to timestamp

1 Answers   Cognizant,


Highlight the need for Performance Tuning.

0 Answers  


What do you mean by tpt in teradata?

0 Answers  


In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

0 Answers  


What are the components provided on node?

0 Answers  


How to copy teradata scripts from ur remote desktop to server machine?

3 Answers  


How many types of index are present in teradata?

1 Answers  


If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

0 Answers  


Categories