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 |
How to view every column and the columns contained in indexes in teradata?
In general, how do you optimze any sql in teradata?
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
What is the difference between global temporary tables and volatile temporary tables?
How to cast date "2015-03-03-012204-000000" to timestamp
Highlight the need for Performance Tuning.
What do you mean by tpt in teradata?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What are the components provided on node?
How to copy teradata scripts from ur remote desktop to server machine?
How many types of index are present in teradata?
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 ?