https://communities.sas.com/t5/SAS-Programming/calculate-time-from-datetime/m-p/929716#M365796 <P>Hello</P> <P>I have a data set with datetime column with format and informat datetimr22.3</P> <P>I want to create a new column called time with time value and format time8.</P> <P>I used the following code&nbsp;</P> <PRE><CODE class=" language-sas">time(effectiveTimestamp) as time format=time8.</CODE></PRE> <P>As I see the time values are not correct,</P> <P>I see for example datetime&nbsp;15MAY2024:03:02:08.977&nbsp; and calculated time&nbsp;14:17:42 but as I see it should be 03:02:08&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ronein_0-1716722364461.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/96774i310A8E4C692A841B/image-size/medium?v=v2&amp;px=400" role="button" title="Ronein_0-1716722364461.png" alt="Ronein_0-1716722364461.png" /></span></P> <P>&nbsp;</P> Sun, 26 May 2024 11:21:47 GMT Ronein 2024-05-26T11:21:47Z https://communities.sas.com/t5/SAS-Programming/calculate-time-from-datetime/m-p/929716#M365796 <P>Hello</P> <P>I have a data set with datetime column with format and informat datetimr22.3</P> <P>I want to create a new column called time with time value and format time8.</P> <P>I used the following code&nbsp;</P> <PRE><CODE class=" language-sas">time(effectiveTimestamp) as time format=time8.</CODE></PRE> <P>As I see the time values are not correct,</P> <P>I see for example datetime&nbsp;15MAY2024:03:02:08.977&nbsp; and calculated time&nbsp;14:17:42 but as I see it should be 03:02:08&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ronein_0-1716722364461.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/96774i310A8E4C692A841B/image-size/medium?v=v2&amp;px=400" role="button" title="Ronein_0-1716722364461.png" alt="Ronein_0-1716722364461.png" /></span></P> <P>&nbsp;</P> Sun, 26 May 2024 11:21:47 GMT https://communities.sas.com/t5/SAS-Programming/calculate-time-from-datetime/m-p/929716#M365796 Ronein 2024-05-26T11:21:47Z https://communities.sas.com/t5/SAS-Programming/calculate-time-from-datetime/m-p/929717#M365797 <P>Please read the description of the <A href="https://documentation.sas.com/doc/en/pgmmvacdc/9.4/lefunctionsref/p096aldg7bq6qsn10m4044qbslka.htm" target="_self">TIME function</A> in the documentation.</P> <P>&nbsp;</P> <P>On the left is an alphabetical list of all SAS functions; right below TIME is the function you want, TIMEPART.</P> Sun, 26 May 2024 11:26:16 GMT https://communities.sas.com/t5/SAS-Programming/calculate-time-from-datetime/m-p/929717#M365797 PaigeMiller 2024-05-26T11:26:16Z