59067 | 10 Aug 2016 @ 12:31 PDT | Inguva | Database | Reply | Convert text to a timestamp |
sel to_timestamp('june 7,2016,12' ,'Month DD,YYYY,HH')
Try This It worked for me
|
59066 | 10 Aug 2016 @ 12:17 PDT | ljohnny | Database | Topic | How to call a function from a procedure call in Teradata | I am creating a stored procedure. Let's call it SP1. In SP1, I need to call SP2, and one of the input parameter needs to be passed in by calling a function Func1
******************************... |
59065 | 10 Aug 2016 @ 12:16 PDT | Inguva | Database | Reply | convert varchar data into timestamp |
sel cast('2016-08-03 08:32:03' as timestamp format'yyyy-mm-ddbhh:mi:ss')
This Worked for me Try once
|
59064 | 09 Aug 2016 @ 11:50 PDT | stami27 | Tools | Reply | TPT load failure - Please suggest | This is the complete installation on this machine
$rpm -qa|sort| grep "15.10"
arc1510-15.10.01.01-1.noarch
bteq1510-15.10.01.03-1.i386
cliv21510-15.10.01.04-1.noarch
fastexp1510... |
59063 | 09 Aug 2016 @ 10:53 PDT | josephmichael.navarro | Tools | Topic | Complete TTU removal | When I run TTUListProducts.exe, it shows that I still have the following apps even though I already uninstall it.
Version Display Name
... |
59062 | 09 Aug 2016 @ 09:40 PDT | jainayush007 | General | Reply | Looking for help with regards to nested aggregates | Alternatively, if we have to do a sub query, is that a way we can achieve a result set as below -
Find Avg within (A,C) and populate only for the first occurance of an I<> in a C<&g... |
59061 | 09 Aug 2016 @ 09:17 PDT | skbinwal | Connectivity | Topic | ODBC connectivity to teradata from RHEL | Hi,
As per a post dated 2013 Teradata odbc didnt support Fast Export or any other utilities. Is it still the case or has there been an update on this.
I need to connect to teradata database from ... |
59060 | 09 Aug 2016 @ 08:58 PDT | jainayush007 | General | Reply | Looking for help with regards to nested aggregates | Hello, I need help as well on a case for nested aggregation as well.In this sample data, I need to find avg of field D over C and then sum them up over A in one query. Can it be done without sub qu... |
59059 | 09 Aug 2016 @ 08:32 PDT | josephmichael.navarro | Connectivity | Reply | Connectivity issues for SQL Assistant 15 | Same thing here adjrock
|
59058 | 09 Aug 2016 @ 07:39 PDT | krishna1985 | Database | Topic | convert varchar data into timestamp | Hi All,
can you please help me with this
I am trying to convert below varchar records into timestamp.
2016-08-03 8:32:03
2016-08-03 11:56:34
Tried mul... |
59057 | 09 Aug 2016 @ 07:34 PDT | krishna1985 | Database | Reply | Convert text to a timestamp | Hi All I am trying to convert
2016-08-03 8:32:03
2016-08-03 11:56:34
which are in varchar to timestamp. can you please help me
|
59056 | 09 Aug 2016 @ 03:41 PDT | dipakrana | Database | Topic | Lock a table row by rowhash | Hello,
Is it possible to explecitely lock a row or a set of rows of a table in a bteq/tpump through out the session?
What will happen if only one row is locked due to update a... |
59055 | 09 Aug 2016 @ 02:57 PDT | tmw | Connectivity | Reply | Excel 2016 VBA Connection | I had an update where the connection was working great in Excel 2016, and everything was great. Then, just last week there was an update that returned to the same problem, and I'm back to... |
59054 | 09 Aug 2016 @ 02:18 PDT | crazyrama5 | Database | Reply | Merge the continuous rows with date range( sequential rows should merge) | Thanks Johannes for responding so quicly.
we got it.
SELECT
CUSTOMER_ACCOUNT_ID
, OLD_RECORD_START_DT &... |
59053 | 09 Aug 2016 @ 02:17 PDT | bjavers | Connectivity | Reply | OLEDB Driver of TD15.10 | Any solution on this one? We have been attempting to use the .net connector however seems like it will work on the initial table create but fails to write subsequent runs.
|
59052 | 09 Aug 2016 @ 01:00 PDT | blue_eyed_byte | Database | Topic | Options to compare contents of two tables | Hello,
From your experience, what is the best option for comparing contents of two tables? Both ways!
- full outer join?
- minus applied both ways?
- except?
- not exist applied both ways?
Le... |
59051 | 09 Aug 2016 @ 11:05 PDT | Johannes Vink | Database | Reply | Merge the continuous rows with date range( sequential rows should merge) | this topic did help me in the past:
https://forums.teradata.com/forum/general/need-help-merging-consecutive-and-overlapping-date-spans
i ended up using dnoets olap function (how typical). however... |
59050 | 09 Aug 2016 @ 11:02 PDT | tdcvgrao | Teradata Studio | Reply | Teradata Studio does not show all of my authorized tables- | Thank you, it is working fine for me now. Appreciate your help.
|
59049 | 09 Aug 2016 @ 10:53 PDT | Johannes Vink | Data Modeling | Reply | AJI creation for a single high priority query | SAP data... Microstrategy... naming convention like that of TAS solution from Teradata... cool!
is a sparse ji also a solution? on spend = Y with a partitioning on fiscal period name.
by the way:... |
59048 | 09 Aug 2016 @ 10:19 PDT | tomnolan | Database | Reply | retrieve row count from Teradata Macro | You must use the EXECUTE MacroName command to execute a macro, and No, it is not possible to use an execute command as a sub-select or derived table.
Hypothetical SQL syntax that is NOT su... |
59047 | 09 Aug 2016 @ 09:42 PDT | tomnolan | Tools | Reply | Reg: SQL Assistant download for Mac OS | SQL Assistant is a Windows-only product, and is not available on Mac OS.
As an alternative, we recommend Teradata Studio or Teradata Studio Express for use on Mac OS. They are availab... |
59046 | 09 Aug 2016 @ 09:34 PDT | DPKKUMARARORA | Database | Reply | Retrieve Rows where a change in values (intwo columns) occured |
Hi,
Please have a look at below solution. Hope this is working as per your requirement.
SELECT
CLIENTID,PLATFID, CPP, &... |
59045 | 09 Aug 2016 @ 09:24 PDT | tomnolan | Connectivity | Reply | Error while getting database functions via JDBC | Work on that is in progress. We plan to provide support for the DatabaseMetaData.getFunctions method in an upcoming release of the Teradata JDBC Driver.
|
59044 | 09 Aug 2016 @ 09:16 PDT | tomnolan | Connectivity | Reply | Teradata JDBC Connection Failure | Teradata Studio Express does not include the Teradata Database.
There are several free versions of the Teradata Database available for download. You must download them separately from Tera... |
59043 | 09 Aug 2016 @ 09:12 PDT | mb255021 | Data Modeling | Reply | AJI creation for a single high priority query | Thanks for your suggestion Mr VandeBerg.
AJIs have a lot of restrictons and I was hoping for a quick fix :)
Which I've discovered isn't possible.
This view only has one query running aga... |