https://communities.sas.com/t5/SAS-Programming/Date-time-format/m-p/780989#M248895 <P>Dear All,</P><P>&nbsp;</P><P>How to convert the below datetime format from character to numeric and vice-versa ?</P><P>&nbsp;</P><P>2021-03-04T08:34</P><P>&nbsp;</P><P>Thanks</P> Thu, 18 Nov 2021 11:11:57 GMT r3570 2021-11-18T11:11:57Z https://communities.sas.com/t5/SAS-Programming/Date-time-format/m-p/780989#M248895 <P>Dear All,</P><P>&nbsp;</P><P>How to convert the below datetime format from character to numeric and vice-versa ?</P><P>&nbsp;</P><P>2021-03-04T08:34</P><P>&nbsp;</P><P>Thanks</P> Thu, 18 Nov 2021 11:11:57 GMT https://communities.sas.com/t5/SAS-Programming/Date-time-format/m-p/780989#M248895 r3570 2021-11-18T11:11:57Z https://communities.sas.com/t5/SAS-Programming/Date-time-format/m-p/780993#M248896 <P>SAS provides the E8601 informats/formats for this:</P> <PRE><CODE class=" language-sas">data test; numdt = input("2021-03-04T08:34",e8601dt16.); format numdt e8601dt16.; run;</CODE></PRE> Thu, 18 Nov 2021 11:25:55 GMT https://communities.sas.com/t5/SAS-Programming/Date-time-format/m-p/780993#M248896 Kurt_Bremser 2021-11-18T11:25:55Z https://communities.sas.com/t5/SAS-Programming/Date-time-format/m-p/780994#M248897 <P>Thank you sooo much !!</P> Thu, 18 Nov 2021 11:31:12 GMT https://communities.sas.com/t5/SAS-Programming/Date-time-format/m-p/780994#M248897 r3570 2021-11-18T11:31:12Z https://communities.sas.com/t5/SAS-Programming/Date-time-format/m-p/780995#M248898 See the paper<BR />VFORMAT Lets SAS® Do the Format Searching<BR />At <A href="http://support.sas.com/resources/papers/proceedings14/1744-2014.pdf" target="_blank">http://support.sas.com/resources/papers/proceedings14/1744-2014.pdf</A> Thu, 18 Nov 2021 11:32:57 GMT https://communities.sas.com/t5/SAS-Programming/Date-time-format/m-p/780995#M248898 Peter_C 2021-11-18T11:32:57Z