- First set desired delimiters.
- Go to menu Tools.
- Select the menu item Options.
- Go to the tab Export/Import.
- You would see a label and a drop down box which says:
- ‘Use this delimiter between columns in files’.
- Choose/Select your desired delimiter.
- Click OK.
You can also have the option present to enclose the columns in single or double quotes.
- Execute the Export option from Teradata SQL Assistant:
- Select File menu and click on the item Export Results.
- You would see a gray menu bar at the top of the screen, you should see the message ‘Results are redirected to a file or table’.
- In the Query window, enter your SQL query.
- Execute your SQL query.
- You will be prompted for the location of the file to be exported to.
- Give a name for the file, and click OK.
- The export process will begin. At the lower left gray margin, you should see a counter incrementing as each row is exported.
- When finished, the gray menu bar at the top of the screen will say ‘Results were written to <filename path>’
- Come out of export mode by selecting File and again clicking Export Results item.
Our Random Articles
- Somdev Devvarman ousts Xavier Malisse 6-1, 3-6,7-6(5)
- How To Choose A Good Online Traffic School
- New Year Wishes 2010
- New Year Wishes
- How to use EXTRACT function with date and time columns
More Links




4 Comments
Material that you are providing is very easy to learn. But it is much better than this , if you ll give the full material of this at ONE LINK.
Thank you
Suresh.
That is right Suresh. This is the reason I have given all the links in one page, please visit this
http://readvitamin.com/teradata/
Hope this helps.
Hi. Can anyone tell me how to extract time from timestamp?
For Example
timestamp=’2008-03-28 14:11:04′
i want time ’14:11:04′ from timestamp through query.
Thanks in advance.
Hi Vaideesh,
If you need only time, you can probably try the following;
SELECT time;
To answer your question you should do something like this.
SELECT CAST(VaideeshTime as time(0)) from timestamp;
VaideeshTime
——–
14:11:04
Hope that helps.