Pages
![]() |
...WHERE DB.LOG_DATE > DATE - INTERVAL '6' MONTH;
30 Aug 2016
| 2 comments
,
|
![]() |
Hi,
16 Jun 2016
| 4 comments
,
|
![]() |
I am looking to build and Effective Date and Expiration Date utilzing a customers next purchase date in the table without a do loop if possible as I do not have access to buid stored procedures.
28 Mar 2016
| 1 comment
,
|
![]() |
Hi,
13 Jan 2016
| 1 comment
,
|
![]() |
I have a VARCHAR column (CALL_START_DATE_TIME) and it's values are as shown below.
2014-OCT-31 15:52:35 2014-JUN-25 13:53:30 2013-DEC-26 19:56:40 2014-AUG-08 22:43:51 2015-APR-22 03:57:04
I need to apply date wise filter on this column as below:
30 Aug 2015
| 5 comments
,
|
![]() |
Hello,
06 Aug 2015
| 1 comment
,
|
![]() |
Good day all,
08 Jul 2015
| 11 comments
,
|
![]() |
Hello, I am a new developer in Teradata world and I'm having to take the quotes from a variable to a software returns me.
I have that: a12.Calendar_Dt in (DATE '11/26/2013')
I can manipulate the start and the end of the variable but not the center.
27 May 2015
| 1 comment
,
|
![]() |
Hi, CREATE VOLATILE TABLE A (ClickLoad_Dt DATE FORMAT 'yyyy/mm/dd'); INSERT INTO A(ClickLoad_Dt) SELECT MAX(CAST (click_dt AS DATE FORMAT 'yyyy/mm/dd') ) FROM B; SELECT * FROM A I get and empty table even though the answer to below query is 5/25/2015
26 May 2015
| 2 comments
,
|
![]() |
I have bteq .RUN command sandwiched by .OS calls which log the start and end date times of the .RUN. The dates are gotten by calls to UNIX 'date' command. The START date is fine, however, my COMPLETED date is always equal to my START date. I don't see how that's possible because the 'date' command is invoked fresh on the COMPLETED line.
01 Apr 2015
,
|
![]() |
Hi,
15 Jan 2015
| 3 comments
,
|
![]() |
Hi,
05 Dec 2014
,
|
![]() |
Good Morning All,
11 Aug 2014
| 1 comment
,
|
![]() |
Hi,
30 Jul 2014
,
|
![]() |
Hi all, create table financial.test (empid integer not null, ename char(30), hiredate DATE FORMAT 'ddmmyyyy' ) primary index (empid);
and inserted data into it and the data is as fallows
empid ename hiredate 1 101 abc 01-01-2000
19 Apr 2014
| 1 comment
,
|
![]() |
Hello everyone,
15 Jan 2014
| 10 comments
,
|
![]() |
Hi,
I am new to Teradata and I am working on query for which I greatly appreciate any help.
i have data in a table as shown below:
date id value 1-Jan-13 1 100 2-Jan-13 1 100 3-Jan-13
07 Jan 2014
| 1 comment
,
|
![]() |
Our Teradata instances are used as a DW for our DB2 mainframe application. In those DW tables, NULL values for date fields are instead represented by '1111-11-11'. I figure this was either done intentionally as part of the design (either mainframe or DW-side) or it was out of necessity due to NULL not being allowed in a DATE field.
13 Nov 2013
| 2 comments
,
|
![]() |
Hi All,
04 Nov 2013
| 2 comments
,
|
![]() |
I'm using this MLOAD script: CREATE MULTISET TABLE "DB"."TABLE" (FIELD1 TIMESTAMP(0) NOT NULL) ; .LAYOUT Layout1 INDICATORS ; .FIELD FIELD1 * CHAR(19) ; .DML LABEL LabelA ; INSERT INTO "DB"."TABLE" (FIELD1) VALUES ( :FIELD1 ) ;
30 Oct 2013
| 5 comments
,
|
![]() |
Hi,
18 Oct 2013
| 7 comments
,
|
![]() |
Hi all First post. Apologies in advance if this question has been asked to death before and/ or if I'm posting this to the wrong section.
01 Oct 2013
| 11 comments
,
|
![]() |
Hi all First post. Apologies in advance if this question has been asked to death before and/ or if I'm posting this to the wrong section.
01 Oct 2013
| 1 comment
,
|
![]() |
Good Day All,
20 Sep 2013
| 3 comments
,
|
![]() |
I am pretty new to teradata and know some basic SQL but I find that I am struggling with this problem.
01 Jul 2013
| 1 comment
,
|
![]() |
Hi All,
03 Jun 2013
| 9 comments
,
|
![]() |
Hi,
08 May 2013
| 2 comments
,
|
![]() |
|
![]() |
|
![]() |
Hi
29 Mar 2013
| 1 comment
,
|
![]() |
Hi,
06 Mar 2013
| 11 comments
,
|
![]() |
Hi
06 Mar 2013
| 1 comment
,
|
![]() |
In my blog entries "Teradata Columnar" and "9.2 Quintillion? What's that all about?", I discussed column partitioning and the increased partition limit that are introduced in TD 14.0. But there are other TD 14.0 partitioning enhancements that you may find useful. The following provides a brief introduction to these enhancements; for more detailed information, see the Orange Book: Increased Partition Limit and other Partitioning Enhancements, the Orange Book: Teradata Columnar, and the TD 14.0 manuals.
17 Sep 2012
| 23 comments
,
|
![]() |
Hi I currently have an SQL code which determines the most recent time that an item was made serviceable.
What I'm now trying to do is to find the first date in which a notification was raised against that item that occured after the serviceable date, and then count the number of days in between.
For example:
14 Aug 2012
| 2 comments
,
|
![]() |
Select EmailAddress, CreatedDate
26 Jun 2012
| 1 comment
,
|
![]() |
Hi, I need to convert date, which is in the format 'MM/DD/YYYY', to the target format 'DD-MMM-YY'. I tried the following query and it worked too. SELECT UPPER(CAST(CAST(CURRENT_DATE AS DATE FORMAT 'DD-MMM-YY') AS CHAR(9))); I would like to know if there is any other better way I can get this done.
21 Jun 2012
,
|
![]() |
Hello,
I'm very much new to Teradata and writting queries as such. I have a CHAR Type column which contains data as follows '2012-01-20 02:32:37.000000'.
How do I convert this CHAR type data to DATE Type, preferably as a timestamp?
Regards, ASR
09 May 2012
| 4 comments
,
|
![]() |
What is the best way to convert 'yyyy-mm-dd' to the Teradata interger storage of a date? (yyyy-1900)mmdd
For example: If my date was April 1, 2012 and it was stored in the database column in the format 'yyyy-mm-dd'. This is what I am trying to get: 1120401
25 Apr 2012
| 2 comments
,
|
![]() |
What is the Maximum date and minimum date value accepted by Teradata?
30 Mar 2012
,
|
![]() |
Hi, In one table of our data warehouse there are 2 columns, "Sceduled Complete Time" and "Actual Complete Time". Both these columns are in the format of "YYYY/MM/DD HH:MM:SS"
14 Feb 2012
| 1 comment
,
|
![]() |
The Viewpoint Portal allows the user to configure their Viewpoint User Profile to display dates in the correct format for any locale and any timezone that is desired. This user profile information is stored on the Viewpoint Server so that all dates can be formatted appropriately either on the server side or on the client side.
19 Dec 2011
,
|
![]() |
Hi, I have a table called Employee with Join Date and Last Date. This table may also contain future employees. Now I want to write a View to list all employees (current and future; but not previous employees). Can anyone suggest me best Date logic to get this information.
29 Sep 2011
| 2 comments
,
|
![]() |
I'm adding up totals within a database and would like to see how the totals change over different time periods. I'm using this code: <code> Select Sum(CASE WHEN Offer_1 = 'Y' THEN 1 ELSE 0 END) as Offer1, Sum(CASE WHEN Offer_2 = 'Y' THEN 1 ELSE 0 END) as Offer2,
13 Sep 2011
| 5 comments
,
|
![]() |
I'm finding an issue I'm having with a Fastload job and a text file with pretty standard dates extremely maddening, and I am sure V12/V13 has changed Fastload's behaviour in some way, as I'm sure what I am trying to do was not this difficult before. Consider a few rows of the tab-delimited text file:
09 Sep 2011
| 1 comment
,
|
![]() |
Hello, does anyone know of an equivalent for the MSSQL data type DATETIME? I cannot seem to find anything in Teradata documentation that indicates such. Using TIMESTAMP is not an option as it is a HEX type. Thanks
19 Apr 2011
,
|
![]() |
Hi I have a select satatement in stored procedure, Inthe where condition, i have b.dt2_month_end =( DATE :THIS_END_DATE - EXTRACT(DAY FROM :THIS_END_DATE))--------statement A if i give hard coded values like
12 Apr 2011
| 4 comments
,
|
![]() |
My data: My current DDL: My current TPT Insert statement: The data is being stored in the database table with century of '19' instead of '20'. My data will always be century of '20': CREATE_DATE
28 Mar 2011
| 1 comment
,
|
![]() |
How do you determine the month-end date when building a date dimension? One of our ETL developers recently pointed out that our date dimension (which I had populated) had incorrect values for month-end date, so I had to find a way to reliably calculate that value.
04 Mar 2011
| 12 comments
,
|
![]() |
Hi all, I'm after some help with converting strings in to dates For example, when i tried to convert '01.12.2010' in to date format '2010-12-01'. I keep getting error "Invalid date supplied"? Can anyone suggest a solution? Many thanks in advance Regards Joe
02 Dec 2010
| 2 comments
,
|
![]() |
Hi, I'm looking for an efficient way to calculate some windowed aggregates over a table with date-stamped records. A simple table would be organized as: Acct_Nbr Date Purchase
06 May 2010
| 1 comment
,
|