-
Converting Teradata data types to Snowflake data types
Bozhack-miller 22-Oct-18 0 5
While migrating from Teradata to Snowflake, few of the Teradata data types aren't supported in Sn... -
How to remove milliseconds from timestamp(6) / datetime in Teradata
nVector 26-Aug-18 0 6
Scenario : We are selecting from a table with a timestamp(6) data type. -
TERADATA - Finding the position of a substring in a string
nVector 22-Aug-18 0 4
We have Data : "Rj 0001 201410212014110301G 20141103ioR4564534 N20141021N 11R" -
How to cast a bigint into decimal in Teradata
nVector 21-Aug-18 0 8
For example, The SAS reporting tool chokes on BIGINT and requires that we cast variables into a i... -
what to install to get started with Teradata?dan-irving 10-Aug-18 1 8
-
How to Insert multiple Rows in Teradata using SQL
nVector 07-Aug-18 0 8
we are creating a volatile table and trying to insert rows to the table. -
How to do inner join on two tables in Teradata
nVector 01-Aug-18 0 4
Scenario: How to I combine columns and rows in the following example in SQL without pulling extra... -
How to find out the tables with specific column names in them in Teradata?
nVector 31-Jul-18 0 6
Scenario: We have column names that we want to look up in the entire DB and list out all tables w... -
DECIMAL datatype behavior while doing calculations in Teradata
nVector 30-Jul-18 0 2
Scenario: Look at the following result we get in Teradata. when multiplying two decimal the resul... -
Teradata UPDATE FROM syntax using row Number
dan-irving 28-Jul-18 0 1
-
Teradata find the First Day of the Year
dan-irving 28-Jul-18 0 5
Here's a way to determine the first day of a year in Teradata SQL -
Move space from one database to another in Teradatavictor 27-Jul-18 0 1
Use the below SQL to move space from one database to another -
Teradata: The UserId, Password or Account is invalid
nVector 23-Jul-18 0 4
While trying to connect to Teradata, if it fails with "The UserId, Password or Account is invalid... -
How to use Teradata OTRANSLATE() function - syntax ?
nVector 13-Jul-18 0 3
Example Scenario: How to count the number of commas in a column