Buscar este blog

viernes, 18 de noviembre de 2011

Mysql Time.

The Tutorial help you to make an example from Time Now in Mysql. In this Tutorial we use now ( ) keywords in Mysql which returns you the current time.

Query systen time.

Open console.
Login in mysql.
run query: select time(now())as Timenow;

mysql> select time(now())as Timenow;
+----------+
| Timenow  |
+----------+
| 09:40:20 |
+----------+
1 row in set (0.00 sec)


 

jueves, 3 de noviembre de 2011

How I can change the time zone of a node on Redhat

How I can change the time zone of a node on Redhat.


Open consola.

The file containing the configuration is located in /etc/localtime. Make a copy of the file and copy the configuration file time zone that is yours. The configuration files are located in /usr/share/zoneinfo

In my case my time zone is Madrid Spain.
[root@vic ~]# ls -la /usr/share/zoneinfo/Europe/Madrid
-rw-r--r-- 1 root root 2593 jun 26 03:43 /usr/share/zoneinfo/Europe/Madrid
Make a copy.
[root@vic ~]# cp /etc/localtime /etc/localtime_bk
Configure new zone.
[root@vic ~]# cp /usr/share/zoneinfo/Europe/Madrid /etc/localtime
cp: overwrite /etc/localtime'? (y/n) Y

Problem solved.