- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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)
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?
Advertisements