How can we know about the starting range of TIMESTAMP data type with the help of MySQL FROM_UNIXTIME() function?

As we know that this function converts a number of seconds into TIMESTAMP value. So by providing 0 seconds as the argument, it will give us the starting range of TIMESTAMP data type.

mysql> Select FROM_UNIXTIME(0);
+-------------------------+
| FROM_UNIXTIME(0)        |
+-------------------------+
| 1970-01-01 05:30:00     |
+-------------------------+
1 row in set (0.00 sec)

Now if we will change the argument from 0 to 60 seconds then the time will be changed by 01 minutes.

mysql> Select FROM_UNIXTIME(60);
+-------------------------+
| FROM_UNIXTIME(60)       |
+-------------------------+
| 1970-01-01 05:31:00     |
+-------------------------+
1 row in set (0.00 sec)

Radhakrishna

Published on 19-Feb-2018 07:05:24

• Related Questions & Answers
• How can we filter data with the help of MySQL subquery?
• In MySQL, how can we use FROM_UNIXTIME() function with format string?
• How can we know the repetition of a value in column with the help of group function COUNT(*) and GROUP BY clause?
• How can I generate days from the range of dates with the help of MySQL views?
• How can we capitalize only first letter of a string with the help of MySQL function/s?
• What is the use of MySQL FROM_UNIXTIME() function?
• How can we change the data type of the column in MySQL table?
• Can we know the last MySQL error?
• Which MySQL query can be used with the help of which we can see the list of MySQL databases?
• How can we subtract values in MySQL table with the help of LEFT JOIN?
• How can we get the list of MySQL server-side help categories?
• How can we display all the records from MySQL table with the help of PHP script?
• How can we display all the records from MySQL table with the help of PHP script that uses mysql_fetch_assoc() function?
• How can we write MySQL query for inner joins with the help of Comma operator?
• How can we write MySQL query for inner joins with the help of keyword JOIN?