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
functions conversion casting binary
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:
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
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'
parameters stored procedure functions
.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?
teradata .net provider canonical functions support
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.
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.
temporal period sql dates programming functions v_database