ReadVitamin

Blogging on Teradata SQL and More

A Brief Introduction On Teradata.

Written by admin in Friday, October 19th 2007 under IT

Teradata Corporation is a global leader in providing data warehousing technologies. Almost all of the largest data warehouses on earth use Teradata RDBMS. Teradata was formerly a division of NCR Corporation with their headquarters in Dayton. They spin-off from NCR on October 1, 2007 and now a truly technology oriented company.

Teradata is a complete relational database management system with its massively parallel processing mechanism running on distributed computing architecture which is scalable in all dimensions of a database system. The beauty of Teradata is that it supports both Symmetric Multi-Processing (SMP) and Massively Parallel Processing (MPP) systems where the distributed functions communicate by means of a fast interconnect structure known as BYNET.

Our Random Articles

4 Comments

suresh Said in Wednesday, January 28th, 2009 @5:42 pm

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.

admin Said in Friday, January 30th, 2009 @5:38 pm

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.

Vaideesh Said in Tuesday, June 2nd, 2009 @11:53 am

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.

admin Said in Tuesday, June 2nd, 2009 @7:20 pm

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.

« How to Post on a Separate/New Page in WordPress

New Year Wishes »

Subscribes To Our Rss Feeds

Feeds Via Readers Feed