How to concat time with present date in MSSQl while converting from mysql : Here is **Mysql code:**

    select concat(date_format(now(),'%Y/%m/%d'),' ','06:00:00 AM')

Trying to concat date with time, getting error like: required two parameters to concat.

**sql:**

    select concat((CONVERT(varchar,getdate(),102),' ','06:00:00 AM')); *not working while converting from mysql to sql*
