0 - 8 of 8 tags for functions

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

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:

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

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'

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 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.

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.