![]() |
...WHERE DB.LOG_DATE > DATE - INTERVAL '6' MONTH;
30 Aug 2016
| 2 comments
,
|
![]() |
Any assistance would be welcomed. I cannot seem to put the Interval in a format that Teradata likes. The column data looks like "00 02:00:00.000000". We are extracting it from ORacle and loading to Teradata version 15.10. I am able to load most other data types no problem, but I cannot find the format needed to make this happy.
28 Jun 2016
| 4 comments
,
|
![]() |
Hi, SELECT cast(CALENDAR_DATE as date format 'YYYY-MM-DD') - INTERVAL '1' YEAR FROM SYS_CALENDAR.CALENDAR
and get error 2666. Invalid dates supplied for CALDATE.
12 May 2014
| 2 comments
,
|
![]() |
hi, i've got this table with the field ampcputime, which is a integer and used the following text in a query
27 Jan 2014
| 4 comments
,
|
![]() |
Hi,
30 Nov 2013
| 4 comments
,
|
![]() |
Hi!
04 Sep 2013
| 5 comments
,
|
![]() |
|
![]() |
Hi, i have these 2 columns defined: WAIT_INTVL INTERVAL HOUR(3) TO SECOND(2) and both are null values a) select COALESCE(WAIT_INTVL, INTERVAL '0' SECOND) from TableT1 b) i can substract (a) with itself select COALESCE(WAIT_INTVL, INTERVAL '0' SECOND) - COALESCE(WAIT_INTVL, INTERVAL '0' SECOND)
13 Jun 2012
| 2 comments
,
|
![]() |
Hi, i have two timestamp columns of 2 fractional seconds precision, i want to take the difference of these 2 timestamps and then have interval upto 0 fractional seconds only For 2 fractional seconds Interval:
25 May 2012
,
|
![]() |
I am trying to have a where clause that checks if the current_date is less than a date field minus 14 days. This is a sample of the code. SELECT PROD_ID, LOC_ID FROM PRODUCT WHERE CURRENT_DATE < (PROMO_DATE - INTERVAL '14' DAY)
16 Feb 2012
| 10 comments
,
|
![]() |
Problem: How do you add or subtract a "fractional second" to a TIMESTAMP column in Teradata?The available documentation is not very clear, so let's look into it using examples. Basic use of INTERVALBuild, Populate, and Query Test Table
11 Feb 2011
| 10 comments
,
|