1. select from_unixtime(1297426454); --> 2011-02-11 20:14:14
2. select date_format(from_unixtime(1297426454),'%Y-%m-%d %H:%i'); --> 2011-02-11 20:14
2012.02.24
1. 数据库连接池, validationQuery [url]http://confluence.atlassian.com/display/JIRA/Surviving+Connection+Closures[/url]
MySQL select 1
Microsoft SQL Server select 1
Oracle select 1 from dual
PostgreSQL select version();
2. select date_format(from_unixtime(1297426454),'%Y-%m-%d %H:%i'); --> 2011-02-11 20:14
2012.02.24
1. 数据库连接池, validationQuery [url]http://confluence.atlassian.com/display/JIRA/Surviving+Connection+Closures[/url]
MySQL select 1
Microsoft SQL Server select 1
Oracle select 1 from dual
PostgreSQL select version();