I have a SQL Server 2012 database on Amazon RDS. Amazon does not allow you to change the timezone at the server level, so anything that requires time is viewed as GMT time instead of my local zone. They said it has to be done at the application level.
Is there a way I can automatically run a procedure, function or command to set the time zone with each database session opened?
My primary access to the database is through Coldfusion programming language, that is where I really need the time zone to be changed.