Thanks everyone I ended up using Luis Example

SELECT [create_date],
  LEFT( CONVERT( varchar(24), [create_date], 121),
  CASE WHEN [create_date] = DATEADD(dd, DATEDIFF(dd, 0, [create_date]), 0)