AWS CLI multiple profiles

When using the AWS CLI, you may be working with multiple AWS accounts.  Therefore, you will want to have multiple profiles.  The profile configuration file is contained in the ~/.aws/config on Linux, OS X, or Unix.  In this file, you will list all of your profiles. At the command prompt or in your .profile file you can have do the following to chose the profile you would like:

export AWS_DEFAULT_PROFILE=<profilename>

AWS RDS : Changing OS time zone

This entry helps you change the database time zone: http://cloudconclave.blogspot.com/2013/08/aws-rds-timezone.html

However, it does not address changed the operating system time zone.  With RDS, the OS timezone can’t be changed (UTC, by design).  Each database engine supports different functions that query OS (for Oracle it is sysdate),   database engine, or session level parameters for timezone information . 

Here’s a quick synopsis of each DB engine’s datetime function details which identifies which calls are OS, database instance, or session based and which include timezone information or if its implied:

·         MySQL: http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html

·         Oracle: http://docs.oracle.com/cd/B19306_01/server.102/b14225/ch4datetime.htm#g1010984

·         SQL Server: http://msdn.microsoft.com/en-us/library/ms186724.aspx