<div>
have you tried <b>YYYYMMDD</b> ? (instead of YYYY/MM/DD)<br />
<br />
what happened when you ran your code? is there an error? (what is that error?)<br />
<br />
Is the column an integer or a string?
</div>


have you tried YYYYMMDD ? (instead of YYYY/MM/DD)

what happened when you ran your code? is there an error? (what is that error?)

Is the column an integer or a string?

<div>
If Date is an integer, try this:<br />
<br />
cast(cast(date1 as char(8)) as date format 'YYYYMMDD')<br />
<br />
or<br />
<br />
cast(cast(date1 as char(8)) as timestamp(6) format 'YYYYMMDD')
</div>


If Date is an integer, try this:

cast(cast(date1 as char(8)) as date format 'YYYYMMDD')

or

cast(cast(date1 as char(8)) as timestamp(6) format 'YYYYMMDD')

<div>
<div class="content wysiwyg-content">
sas date in teradata<br />
<br />
date1 <br />
20171101<br />
20171101<br />
How do you convert a date column stored as sas date value in teradata to a sas date format using proc sql? I am getting an error message.<br />
<br />
Here is my code:<br />
<br />
&nbsp; &nbsp;
<pre><code id="code-10-29061533-1">  proc sql;
  Create table test
   AS
   select cast(cast(date1 as date format 'YYYY/MM/DD') as char(10)) as 'date_d'
   from td2.db;</code></pre>
</div>
</div>


sas date in teradata

date1 
20171101
20171101
How do you convert a date column stored as sas date value in teradata to a sas date format using proc sql? I am getting an error message.

Here is my code:

   (CODE)

convert a date column stored as sas date value in teradata using proc sql

The Statistical Analysis System (SAS) programs consist of two steps, the DATA step and the PROC step. The DATA step reads data and prepares it for use by subsequent DATA or PROC steps. A SAS procedure (PROC) is a collection of statements that execute a certain task. SAS procedures have their own statements and commands, but many are shared among procedures. JMP is the graphical user interface for SAS, and is used in applications such as Six Sigma, quality control and engineering, design of experiments and scientific research.