topic Re: Convert Timestamp to date9. in Administration and Deployment https://communities.sas.com/t5/Administration-and-Deployment/Convert-Timestamp-to-date9/m-p/103342#M954 <HTML><HEAD></HEAD><BODY><P>the datepart function converts an integer datetime to an integer date value.</P><P>the example here converts text datetime to integer date. </P></BODY></HTML> Fri, 24 Aug 2012 13:24:34 GMT mojerry2 2012-08-24T13:24:34Z Convert Timestamp to date9. https://communities.sas.com/t5/Administration-and-Deployment/Convert-Timestamp-to-date9/m-p/103339#M951 <HTML><HEAD></HEAD><BODY><P>Hello guys,</P><P>i do convert this time stamp:</P><P>23DEC2004:20:02:53.000000 (char25)</P><P>in </P><P>23DEC2004&nbsp; (date9.)</P><P></P><P>Please, help.</P><P></P><P>Thank's</P></BODY></HTML> Fri, 24 Aug 2012 10:32:17 GMT https://communities.sas.com/t5/Administration-and-Deployment/Convert-Timestamp-to-date9/m-p/103339#M951 Cello23 2012-08-24T10:32:17Z Re: Convert Timestamp to date9. https://communities.sas.com/t5/Administration-and-Deployment/Convert-Timestamp-to-date9/m-p/103340#M952 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try this..</P><P></P><P>data test;</P><P>input time $ 25.;</P><P>date=input(time,date9.);</P><P>format date date9.;</P><P>cards;</P><P>23DEC2004:20:02:53.000000</P><P>;</P><P>run;</P><P></P><P>Thanks,</P><P>Shiva</P></BODY></HTML> Fri, 24 Aug 2012 10:51:49 GMT https://communities.sas.com/t5/Administration-and-Deployment/Convert-Timestamp-to-date9/m-p/103340#M952 shivas 2012-08-24T10:51:49Z Re: Convert Timestamp to date9. https://communities.sas.com/t5/Administration-and-Deployment/Convert-Timestamp-to-date9/m-p/103341#M953 <HTML><HEAD></HEAD><BODY><P><img id="smileywink" class="emoticon emoticon-smileywink" src="https://communities.sas.com/i/smilies/16x16_smiley-wink.png" alt="Smiley Wink" title="Smiley Wink" /></P><P></P><P>Thank's</P></BODY></HTML> Fri, 24 Aug 2012 12:04:13 GMT https://communities.sas.com/t5/Administration-and-Deployment/Convert-Timestamp-to-date9/m-p/103341#M953 Cello23 2012-08-24T12:04:13Z Re: Convert Timestamp to date9. https://communities.sas.com/t5/Administration-and-Deployment/Convert-Timestamp-to-date9/m-p/103342#M954 <HTML><HEAD></HEAD><BODY><P>the datepart function converts an integer datetime to an integer date value.</P><P>the example here converts text datetime to integer date. </P></BODY></HTML> Fri, 24 Aug 2012 13:24:34 GMT https://communities.sas.com/t5/Administration-and-Deployment/Convert-Timestamp-to-date9/m-p/103342#M954 mojerry2 2012-08-24T13:24:34Z