Never understood why SQL Server doesn't let you specify a custom date format like:

```
CONVERT(varchar(22),yourdate,'mm/dd/yyyy hh:mi:ss AM')

```

and that you have to use the style numbers they provide, and then use REPLACE, SUBSTRING etc. to come up with the format you want.

Is there a better way? What is the best way to come up with the (pretty common) format I want above? Anything I come up with is way too complex.

Thanks.