0 - 8 of 8 tags for functions
convert integer value to binary

Hi 
Please advise in Teradata how to convert integer value to binary and then back to integer ? If there is any function for that ?
For example: integer value is 50, binary will be 00110010 and again from 00110010 back to 50.
 
Thanking You
Santanu Ghosh

By Santanu84, 04 Apr 2016 | Tagged: functions conversion casting binary | 7 comments
Functions doesn't work with the ODBC connection

Hello everyone,
I have lately install an ODBC connection on a new server that we have set up.
 
I connect to the database through Qlikview (a datavisualisation tool), it works well except when I want to use a teradata function.
 
For example:

By Laura, 19 Oct 2015 | Tagged: functions | 3 comments
Teradata function from_gmt2

Hi
I need to convert these statments from using  AT TIMEZONE to FROM_GMT2.  Help is very much appreciated
c_timestamp is a column of timestamp(0) type
TO_CHAR(CAST(CAST(c_timestamp AT TIME ZONE 'America Mountain' AS VARCHAR(19)) AS TIMESTAMP(0)),'YYYY-MM-DD HH24:MI:SS') AS C_TIMESTAMP_MDT

By uco, 31 May 2014 | Tagged: teradata Teradata sqls functions database
Parameterizing Like clause

We have a requirement to mask sensitive information being loaded into the tables. Let's say we had the first three groups in place, the fourth one came in as a new requirement, and so had to make a coding change. We currently have logic similar to this.

 

Case when diagnosis_description like '%psych%' Then 'sensitive info'

By Renji, 12 Feb 2014 | Tagged: parameters stored procedure functions | 1 comment
Introduction to Teradata Aster Discovery Platform

The Teradata® Aster® Discovery Platform is the industry’s first next-generation, integrated discovery platform that provides powerful insights from big data.

By DebraH, 16 Jan 2014 | Tagged: Data Discovery Discovery Discovery Platform Integrated big data Big Data Analytics Teradata Aster aster teradata graph SQL-GR SQL-MapReduce sql analytics Multiple Analytics SNAP Framework SQL Interface Discovery architecture Aster File Store File system Data store Unified Object store Pre-Built Packaged functions Discovery Portfolio Visualizations Aster Lens appliance hadoop mapreduce YARN Unstructured Data Multi-Structured Data hdfs
.NET Data provider - Canonical functions support

Alright. So I looked at this page: http://developer.teradata.com/doc/connectivity/tdnetdp/14.10/webhelp/EntityProviderCanonicalFunctions.html. It mentions that canonical functions for .NET 4.0 are supported under the "Teradata" namespace. Where in the world is this namespace?

By sundarvenkata, 20 Jul 2013 | Tagged: teradata .net provider canonical functions support | 6 comments
Teradata 13.10 SQL Language Functions and User Defined Ordered Analytic Functions

Teradata 13.10 continues the strategy of delivering features that enable extending the Enterprise Data Warehouse functionality. SQL Language User Defined Function (UDFs) allows function to be implemented in SQL which is a natural fit for SQL writers. This session describes the feature and use cases. It also describes other enhancements in Teradata13.10 which includes User Defined Ordered Analytic Functions and new system functions for BIT, string and numeric processing.

By DebraH, 09 May 2011 | Tagged: udf extensibility functions ordered analytic
Exploring Teradata 13's PERIOD Functions

The PERIOD data type was introduced in Teradata 13.0. This follow-on article builds on the first article (Exploring Teradata 13's PERIOD Data Type) and will again make heavy use of examples, but this time we will dig into the functions that are part of this new feature set.

If you have not read the first article, consider doing that now and then returning here. The examples here will use the tables introduced in the first article and add a few more.

By RobG, 15 Feb 2011 | Tagged: temporal period sql dates programming functions v_database | 4 comments