I've been in a psych ward a few times, at most two weeks. If you are suicidal, I think staying in hospital might be good for you. You'll be in a safe environment, and your meds may be tweaked (or you'll be put on meds if you aren't already on any).

If you're interested in personal experiences, there was a thread about it somewhere....