Can my retina MacBook Pro SSD drive go to sleep?
As to what I'm aware, an SSD does not classify as a hard disk, therefore it will not go to sleep as part of this option. (I'm not even sure you can make them go to sleep to begin with.)

Using a laptop with an internal SSD as its only form or storage will make this setting of no use. However if there is say an external HDD plugged in, it will abide to this setting.

But back on topic, an SSD will not obey this setting.