<div>
Hi<br />
<br />
How have you framed your SQl query. &nbsp;Is it a pss-thru query:<br />
<br />
PROC SQL;<br />
&nbsp; Connect to terabase(connection details);<br />
&nbsp; select * from connection to terabase(<br />
&nbsp; &nbsp; &nbsp; SQL query<br />
);<br />
quit;<br />
<br />
or are you using libname access?<br />
<br />
If you are using libname access, SAS should do the conversion for you, without the need for a CAST statement<br />
<br />

</div>


Hi

How have you framed your SQl query.  Is it a pss-thru query:

PROC SQL;
  Connect to terabase(connection details);
  select * from connection to terabase(
      SQL query
);
quit;

or are you using libname access?

If you are using libname access, SAS should do the conversion for you, without the need for a CAST statement



<div>
This was done by pass through
</div>


<div>
<div class="content wysiwyg-content">
Hi I am using SAS with a teradata database. &nbsp;In my SQL statement, I am trying to write a WHERE statement querying only for certain date ranges. &nbsp;The date variable in the teradata datebase is numeric and is 6 digits. &nbsp;For example 82311 is August 23, 2011. &nbsp;Can someone help me with the syntax? &nbsp;Thanks<br />
<br />
where CAST ( (CAST (run_date AS date FORMAT 'MMDDYY') ) AS CHAR(6)) &gt;= 080111);<br />
<br />
ERROR: Teradata row not delivered (trget): Invalid date supplied for
</div>
</div>


Hi I am using SAS with a teradata database.  In my SQL statement, I am trying to write a WHERE statement querying only for certain date ranges.  The date variable in the teradata datebase is numeric and is 6 digits.  For example 82311 is August 23, 2011.  Can someone help me with the syntax?  Thanks

where CAST ( (CAST (run_date AS date FORMAT 'MMDDYY') ) AS CHAR(6)) >= 080111);

ERROR: Teradata row not delivered (trget): Invalid date supplied for

teradata-numeric to date (query)

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Enterprise software, also known as enterprise application software (EAS), is computer software used to satisfy the needs of an organization, including businesses, schools, interest-based user groups, clubs, charities, or governments. Services provided by enterprise software are typically business-oriented tools such as online shopping and online payment processing, interactive product catalogue, automated billing systems, security, enterprise content management, IT service management, customer relationship management (CRM), enterprise resource planning (ERP), business intelligence (BI), project management, human resource management (HR), manufacturing and supply chain management, enterprise application integration (EAI), and enterprise forms automation. Enterprise software is often available as a suite of customizable programs that require specialist capabilities.