Separate Data in multi column

Question

Can any one help me to fetch separate data from database into multi column.

how to build this query in sql server 2008. 

 

i have data like    1003,1253569585,05/05/2020 10:25:13

i want to fetch this data in sepatare filed and if emp in time sec is odd then status is "IN" and time sec is even then "Out" 

please help me in this query...