The only time you'll get your password sent from SMF via email, is when you first register. There is an option to change it being emailed, however there are pros and cons to doing so.
All passwords are hashed when stored in the database, and are non-retrievable. The only way you could retrieve them is via brute force methods.