UNIX_TIMESTAMP « Date Time « SQL / MySQL






  1. SQL / MySQL
  2. Date Time
  3. UNIX_TIMESTAMP
1.UNIX_TIMESTAMP calculation
2.UNIX_TIMESTAMP( ) can convert DATE values to seconds.
3.Converting Between Date-and-Time Values and Seconds
4.The number of seconds between dates that lie two weeks apart can be computed like this:
5.To convert the interval in seconds to other units, perform the appropriate arithmetic operation.