Convert the query (concat and convert) Mysql query into MSSQL

select UNIX_TIMESTAMP(STR_TO_DATE((select concat(date_format(now(),'%m/%d/%Y'),' ','12:00:01 AM')),'%m/%d/%Y %h:%i:%s%p'))) and (select UNIX_TIMESTAMP(STR_TO_DATE((select concat(date_format(now(),'%m/%d/%Y'),' ','06:00:00 AM')),'%m/%d/%Y %h:%i:%s%p')))

Here i am trying to convert and concat the query.is there any other format to convert the query from mysql to MSSQL