String sql = "select id, query_sql, CONVERT_TZ(sync_datetime,'+00:00','-05:30') as  sync_datetime from tblsync_master where id=1";

            List<Map<String, Object>> data = template.queryForList(sql);

List<Map<String, Object>> data = template.queryForList(sql);

template.setQueryTimeout(3);

spring.datasource.url=jdbc:mysql://localhost/test
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.jpa.hibernate.naming.strategy=org.hibernate.cfg.EJB3NamingStrategy
spring.jpa.database-platform=org.hibernate.dialect.MySQL5InnoDBDialect
hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
hibernate.show.sql=false
hibernate.hbm2ddl.auto=update
#hibernate 5 naming property
spring.jpa.hibernate.naming.physical-strategy=org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl

#max active connection with mysql
#spring.datasource.tomcat.max-active=10
spring.jta.bitronix.datasource.max-pool-size=25

spring.datasource.tomcat.testOnBorrow=true
spring.datasource.tomcat.validationQuery=SELECT 1
spring.datasource.dbcp2.test-on-borrow=true