It really depends on what kind of value that your service is offering.
For instance, Pivotal Tracker offers a 90 day free trial. Their product requires that the users/teams become dependant on their service so that they can't live without it.
Offering a 1 day trial here, when it works on weekly iterations just wouldn't work. Equally, offering a 30 day trial, really only provides 4 iterations, or probably about 20-30 stories. This definitely isn't enough to "hook" the users and lock them in due to the amount of time that they have invested.
If you are in it for the long haul and your service really does provide great value for the users then getting your users invested in the product might come at the cost of giving more free trials away for free.
Some services are freemium remember. They are unlimited trial times in effect, because the upsells and bolt ons are where they make money.
Equally, however, some services 45-60-90 days would definitely be too much, and you could be losing money.
You can't just say in isolation, 45 days is the sweetspot for 100% of startups, because it ignores any other factors such as the service value that the product fills.
Equally, if your product takes time to kick in, you wouldn't want to offer 30 day trial. For instance, if you were a marketing platform like HomeAway or a paid version of AirBnB. Offering a short trial might not be the best idea because it takes time for the value of the service to really kick in.