6/06/2014

Error: Package: google-chrome-stable-XXXXXXX.x86_64 (google-chrome) Requires: libstdc++.so.6(GLIBCXX_3.4.15)(64bit)

When you install chrome on centos, you may require to install : libstdc++.so.6(GLIBCXX_3.4.15)(64bit).









The error may be like:
Error: Package: google-chrome-stable-35.0.1916.114-1.x86_64 (google-chrome)
           Requires: libstdc++.so.6(GLIBCXX_3.4.15)(64bit)

Now you may try to install chromium compiled for centos.


1. Download
    wget http://people.centos.org/hughesjr/chromium/6/x86_64/RPMS/chromium-31.0.1650.63-2.el6.x86_64.rpm

2.install
   rpm -ivh chromium-31.0.1650.63-2.el6.x86_64.rpm




Now you may use chrome on your centos.

6/05/2014

MYSQL Unix time stamp conversion

When you want to convert the time stamp on mysql, please use the following code

1. time stamp to time
select FROM_UNIXTIME(1425933810);
+---------------------------+
| FROM_UNIXTIME(1425933810) |
+---------------------------+
| 2015-03-10 05:43:30       |
+---------------------------+
1 row in set (0.00 sec)

2. time to time stamp

select UNIX_TIMESTAMP('2015-11-06 10:10:10');
+---------------------------------------+
| UNIX_TIMESTAMP('2015-11-06 10:10:10') |
+---------------------------------------+
|                            1446772210 |
+---------------------------------------+
1 row in set (0.00 sec)