![]() |
HI
03 Oct 2014
| 1 comment
,
|
![]() |
What is Teradata & how does it differ from other conventional Systems?
06 Sep 2014
| 27 comments
,
|
![]() |
Hi guys,
14 Jun 2014
,
|
![]() |
Hi guys, INSERT INTO aidar.time_ansi ( "ID_1","COL_1","COL_2" ) SELECT last_key_1, ( CASE
13 Jun 2014
| 20 comments
,
|
![]() |
Dear SQLers,
04 Dec 2013
| 9 comments
,
|
![]() |
Hi,
30 Nov 2013
| 4 comments
,
|
![]() |
My data has four columns date, departure, destination and depart time. I have a case statement that groups depart times. It works fine but it does not group departures between 18:31 and 19:00. Time is
11 Nov 2013
| 3 comments
,
|
![]() |
Dear All,
11 Oct 2013
| 6 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
,
|
![]() |
02 Jan 2013
| 2 comments
,
|
![]() |
Hi,
11 Dec 2012
| 12 comments
,
|
![]() |
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
,
|
![]() |
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
,
|
![]() |
From the TD user manual, i got this as an example of timestamp to time conversion: SELECT CAST(cast('1997-12-31 23:59:59' as timestamp(5)) AS TIME(5) WITH TIME ZONE); But why the time zone? how can I extract just the time with no timezone. I didn't define any timezones anywhere... Any thoughts on this would be great
12 Feb 2010
| 1 comment
,
|
![]() |
These UDFs implement difference determination in months/years using smaller units of granularity, days/months, to accurately calculate the difference.
15 Jun 2008
,
|