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)

 

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.