Visit Teradata.com Home    Search    Guidelines    Member List

Welcome Guest ( Login | Register )       Recent Posts    Popular Topics

Teradata Discussion Forums » Teradata » Teradata Database » CAST TIME(0) to INTERVAL HOUR TO SECOND

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

CAST TIME(0) to INTERVAL HOUR TO SECOND Rate Topic Display Mode Topic Options Author Message Koushik Chnadra Posted 8/7/2009 6:51:50 AM Forum Member Group: Forum Members Last Login: 8/7/2009 11:10:27 AM Posts: 26, Visits: 93 Hi, Can you pleae help to CAST a TIME(0) data type to INTERVAL HOUR TO SECOND. Regards, Koushik Regards, Koushik Post #16474 pawan0608 Posted 8/7/2009 7:52:30 AM Forum Member Group: Forum Members Last Login: 2 days ago @ 7:45:03 AM Posts: 39, Visits: 169 I hope below SQL should work for you SEL (CURRENT_TIME(0) - TIME '00:00:00') HOUR TO SECOND(0) Post #16477 « Prev Topic | Next Topic »

Reading This Topic Active Users: 0 ( 0 guests, 0 members, 0 anonymous members ) No members currently viewing this topic.

Forum Jump... ---------------- Forum Home Search Members List Calendar Who's Online ----------------  Teradata   |-- Analytical Applications   |-- Data Warehousing   |-- Drivers and UDFs   |-- Jobs   |-- Marketing Tips and CRM Best Practices   |-- PARTNERS 2009   |-- Partner software applications/questions   |-- Teradata Advanced Analytics User Group   |-- Teradata Database   |-- Teradata Tools and Utilities   |-- Training   |-- Teradata Viewpoint   |-- Teradata Geospatial   |-- Active Data Warehousing  Teradata Discussion Forum Guidelines   |-- Forum Guidelines and Rules All times are GMT -5:00, Time now is 8:52am

Powered By InstantForum.NET v4.1.4 © 2009 Execution: 0.063. 6 queries. Compression Disabled.