Pages
![]() |
Hi, I am trying to create my first function in Teradata SQL Assistant using a script I found on the internet. the purpose of the function is to convert a timestamp to a unix timestamp and is as follows;
30 Jun 2016
| 1 comment
,
|
![]() |
Hi All, --output: '2016-06-07 00:00:00'
13 Jun 2016
| 3 comments
,
|
![]() |
Hi All, Mar 22, 2016 12:06:35 PM
31 May 2016
| 1 comment
,
|
![]() |
I am using mload to load in a large data set. However, I can't get any of hte data to load because of the error 6760. I know it deals with the timestamp.
28 Mar 2016
| 1 comment
,
|
![]() |
I need to query a teradata table by referencing a column that is of type Timestamp(6). I'm not successful at getting the right format so far. What do I need to set the Size, Precision, and Scale values to for this to work. (By size, precision, and scale I mean these parameter values in Visual Studio's Dataset Editor)
21 Nov 2015
| 1 comment
,
|
![]() |
Hi all, it's my firt post, I hope you can help me here. Within the same day for one ID I have many overlapping events. Basically each event is added on top of scheduled events instead of overwriting existing records. Here is example:
14 Sep 2015
| 4 comments
,
|
![]() |
There is a requirement like this:
23 Aug 2015
| 6 comments
,
|
![]() |
Hello,
06 Aug 2015
| 1 comment
,
|
![]() |
Hi all,
23 Jul 2015
| 3 comments
,
|
![]() |
Hello, TimeStamp(FORMAT 'YYYYMMDD') (CHAR(8)) AS CALL_DT, TimeStamp(FORMAT 'HH:MI:SS') (CHAR(8)) AS CALL_TIME, CASE WHEN TEMP1>=240000
09 Jul 2015
| 1 comment
,
|
![]() |
Hello, I'm looking at clinic data and I'd like to group my check-in times into three main categories: 1) 7am-4pm, 2) 4:01pm-6pm, and 3) 6:01pm-11:59pm. Check-in time is formatted as follows: mm/dd/yyyy hh:mm:ss, and is 24-hour. But I reformatted it like this: hh:mi:ssbt. So now it gives me a 12-hour time with an AM/PM designation.
23 Jun 2015
| 3 comments
,
|
![]() |
Hi,
15 Jan 2015
| 3 comments
,
|
![]() |
Hi ,
13 Nov 2014
| 2 comments
,
|
![]() |
Hi All,
08 Oct 2014
| 2 comments
,
|
![]() |
Hi,
10 Sep 2014
| 4 comments
,
|
![]() |
In our database we have a system-generated ID that is built off of the timestamp. It’s not a date or time format, it’s a string, like (20130405103422), which is essentially the year, month, day, hour, minute and second that the record was created. I want to join it to another field, which is date, but I need to convert it first. How do I do that
08 Sep 2014
| 2 comments
,
|
![]() |
My customer has loaded a TD test table with a date & time column that looks like this:
12 Aug 2014
| 1 comment
,
|
![]() |
Hi,
30 Jul 2014
,
|
![]() |
my timestamps are in this format 1405720077410
18 Jul 2014
| 7 comments
,
|
![]() |
Hi,
07 Mar 2014
| 6 comments
,
|
![]() |
Hi all,
02 Feb 2014
| 4 comments
,
|
![]() |
Hi Experts,
24 Jan 2014
| 7 comments
,
|
![]() |
Running the following query: SELECT MAX(timeValue), MIN(timevalue) FROM OurDB.DimTime Returns the result of:
14 Jan 2014
| 3 comments
,
|
![]() |
Dear All,
11 Oct 2013
| 6 comments
,
|
![]() |
Hello.
27 Sep 2013
| 2 comments
,
|
![]() |
Hello,
03 Jun 2013
| 3 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
,
|
![]() |
I have a timestamp with time zone field and I would like to get the number of seconds that have elapsed from the start of that day. This seems like it should be very trivial but I've searched for hours and tried many things that don't work. What is a simple method for getting the number of seconds?
22 Jan 2013
| 2 comments
,
|
![]() |
I have timestamp values in Varchar field. Trying to populate this data in a table where field types are properly defined, and I am unable to push data from table a (timestamp is in varchar) to table b (where I want the date to be in timestamp field). Getting error message 2666. How can I find out fields with bad dates only?
13 Dec 2012
,
|
![]() |
I am bumping into timestamp conversion error when loading to timestamp column with time zone. The table in the column define as 0005 DEFINE device_dt_ut (VARCHAR(32)),
17 Nov 2012
| 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
,
|
![]() |
estimated cardinality for the following predicate towards timestamp column is far too high vs date column 1) Table DDL: --------------------------------------
12 Jul 2012
| 7 comments
,
|
![]() |
Tables that are dropped and reloaded daily, how can I determine if the table has been today's load, not yesterday's?
26 Jun 2012
| 7 comments
,
|
![]() |
The Teradata Temporal feature, available with Teradata 13.10 allows the customer to capture, track, and analyze the full history of evolving business data rather than just the most current updates.
06 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
,
|
![]() |
Hi,
I just needed to get the difference between 2 Timestamps in minutes and couldn't find any useful way on the net, so I decided to add my own solution here, in case someone else needs something similar.
12 Mar 2012
| 2 comments
,
|
![]() |
Hello, I am sometimes encountering a syntax error (3706) when using CASE with an IN clause, see (1) below. The error is happening with timestamp columns and sometimes with varchar's (when the individual varchar values in the IN are concatenated, ie. col1 || col2). Any info on this?
09 Feb 2012
| 6 comments
,
|
![]() |
I am trying to call Stored Procedure with parameters. Procedure have two TIMESTAMP parameters for example use below one:
12 Jan 2012
| 2 comments
,
|
![]() |
Teradata Database 14.0's new partition limit of 9223372036854775807 (over 9 quintillion) is coming!
29 Nov 2011
,
|
![]() |
Hi All, Can you please explain the concept for timestamp(0),timestamp(1) ....timestamp(6)..? Thanks in advance for the help.
06 Sep 2011
| 3 comments
,
|
![]() |
Is it possible to get the timestamp to display the timezone like this using SQL? What I have so far: SQL: RESULTS: myTimeZone myTimeZone2
08 Apr 2011
| 1 comment
,
|
![]() |
This gets the date, how can I get the full timestamp? SELECT (CAST('1970/01/01' AS DATE FORMAT 'yyyy/mm/dd')) + CAST(my_time/86400 AS INTEGER) AS CONVERTED_TIME I have a table with a column that is an integer and has Unix epoch time data.
06 Apr 2011
| 2 comments
,
|
![]() |
Hi Is there a way to convert TIMESTAMP data to ISO 8061 format, so the result will be something like: ' 2011-04-04T12:57:18.530'?
04 Apr 2011
| 1 comment
,
|
![]() |
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
,
|
![]() |
Hello Folks, I have a date column in one table (Table A) that I have to insert into a date column in another table (Table B) However,
23 Mar 2011
| 4 comments
,
|