https://communities.sas.com/t5/SAS-Programming/How-to-remove-milliseconds-from-datetime26-6-format/m-p/373030#M89229 Sorry Reeza, I mistakenly marked my comment as a solution. I intended to mark your answer as a solution. Tue, 04 Jul 2017 15:05:44 GMT nikunjgattani 2017-07-04T15:05:44Z https://communities.sas.com/t5/SAS-Programming/How-to-remove-milliseconds-from-datetime26-6-format/m-p/372916#M89192 <P>I have a column in a sas dataset whose format and informat both are datetime26.6<BR />I need only date and time with hh:mm:ss.<BR />I tried reading date column using datetime26.6/anydtdte./anydtdtm. format but none works.</P> <P>Does anyone have any idea how to read and convert the given column.</P> Tue, 04 Jul 2017 05:26:25 GMT https://communities.sas.com/t5/SAS-Programming/How-to-remove-milliseconds-from-datetime26-6-format/m-p/372916#M89192 nikunjgattani 2017-07-04T05:26:25Z https://communities.sas.com/t5/SAS-Programming/How-to-remove-milliseconds-from-datetime26-6-format/m-p/372920#M89193 <P>Pls share the sample data.</P> Tue, 04 Jul 2017 06:00:45 GMT https://communities.sas.com/t5/SAS-Programming/How-to-remove-milliseconds-from-datetime26-6-format/m-p/372920#M89193 TarunKumar 2017-07-04T06:00:45Z https://communities.sas.com/t5/SAS-Programming/How-to-remove-milliseconds-from-datetime26-6-format/m-p/372921#M89194 <P>Milliseconds are stored as decimals, so round the value using the ROUND function.&nbsp;</P> Tue, 04 Jul 2017 06:05:22 GMT https://communities.sas.com/t5/SAS-Programming/How-to-remove-milliseconds-from-datetime26-6-format/m-p/372921#M89194 Reeza 2017-07-04T06:05:22Z https://communities.sas.com/t5/SAS-Programming/How-to-remove-milliseconds-from-datetime26-6-format/m-p/372943#M89197 <P>24APR2017:17:03:00.000000<BR />22APR2017:15:02:39.000000<BR />15APR2017:17:42:46.000000<BR />10APR2017:20:05:31.000000<BR />23APR2017:19:27:55.000000<BR />02APR2017:19:07:03.000000<BR />05APR2017:18:27:11.000000<BR />18APR2017:16:13:20.000000<BR />28APR2017:19:24:31.000000</P> <P>&nbsp;</P> <P>I need only date and hh:mm:ss</P> Tue, 04 Jul 2017 08:49:45 GMT https://communities.sas.com/t5/SAS-Programming/How-to-remove-milliseconds-from-datetime26-6-format/m-p/372943#M89197 nikunjgattani 2017-07-04T08:49:45Z https://communities.sas.com/t5/SAS-Programming/How-to-remove-milliseconds-from-datetime26-6-format/m-p/372946#M89198 <P>Thanks Reeza, Using Round function is working.</P> Tue, 04 Jul 2017 09:03:49 GMT https://communities.sas.com/t5/SAS-Programming/How-to-remove-milliseconds-from-datetime26-6-format/m-p/372946#M89198 nikunjgattani 2017-07-04T09:03:49Z https://communities.sas.com/t5/SAS-Programming/How-to-remove-milliseconds-from-datetime26-6-format/m-p/373022#M89226 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/27505">@nikunjgattani</a>&nbsp;marking your own answer as the solution is not correct unless you find and post the solution to your question.&nbsp;</P> Tue, 04 Jul 2017 14:41:01 GMT https://communities.sas.com/t5/SAS-Programming/How-to-remove-milliseconds-from-datetime26-6-format/m-p/373022#M89226 Reeza 2017-07-04T14:41:01Z https://communities.sas.com/t5/SAS-Programming/How-to-remove-milliseconds-from-datetime26-6-format/m-p/373030#M89229 Sorry Reeza, I mistakenly marked my comment as a solution. I intended to mark your answer as a solution. Tue, 04 Jul 2017 15:05:44 GMT https://communities.sas.com/t5/SAS-Programming/How-to-remove-milliseconds-from-datetime26-6-format/m-p/373030#M89229 nikunjgattani 2017-07-04T15:05:44Z