I need to convert dates of varying strings. They come in 3 different ways.

**yyyy/mm/dd**

**mm/dd/yyyy**

or **blank** (can fill in some default)

What is a good way to handle this situation for an INSERT statement?