Apply OS: Windows

Apply Navicat Product: Navicat for MySQL, Navicat for MariaDB, Navicat Premium

Apply Navicat Version No.: All


You need to change the SQL manually and use the FROM_UNIXTIME() function to convert unix timestamp to MySQL timestamp format. To do this, please follow steps below:

  1. In the Query Designer, select SQL tab.
  2. Right click the SQL statement and choose Edit SQL.
  3. Edit the SQL using FROM_UNIXTIME()

Note: If you change the SQL manually, you cannot use the visual design tabs (Fields, Calcs, Group, Search and Sort) to modify the query.

For more information, please refer to - http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html and our user manual

Have more questions?
Submit Ticket