convert integer value to binary
,
04 Apr 2016
| 7 comments
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
Functions doesn't work with the ODBC connection
,
19 Oct 2015
| 3 comments
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:
Teradata function from_gmt2
,
31 May 2014
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
Parameterizing Like clause
,
12 Feb 2014
| 1 comment
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'
Introduction to Teradata Aster Discovery Platform
,
16 Jan 2014
The Teradata® Aster® Discovery Platform is the industry’s first next-generation, integrated discovery platform that provides powerful insights from big data.
.NET Data provider - Canonical functions support
,
20 Jul 2013
| 6 comments
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?
Teradata 13.10 SQL Language Functions and User Defined Ordered Analytic Functions
,
09 May 2011
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.
Exploring Teradata 13's PERIOD Functions
,
15 Feb 2011
| 4 comments
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.