Will/Does MySQL support DATETIMEOFFSET?

mysql datetimeoffset
CuriousGeorge picture CuriousGeorge · Aug 19, 2015 · Viewed 8.5k times · Source

I'm currently using a shared hosting plan, and I'm not sure which version of MySQL it's using, but it does not seem to support the DATETIMEOFFSET type.

Does a version exists of MySQL that supports DATETIMEOFFSET? or are there plans for it to be implemented in the future?

Answer

duskwuff -inactive- picture duskwuff -inactive- · Aug 19, 2015

As far as I can tell, the DATETIMEOFFSET type is specific to Microsoft SQL Server. It is not part of the SQL standard, and is not supported by any current or past version of MySQL.

The closest equivalent to this data type in MySQL is the TIMESTAMP data type. This data type stores an absolute date and time to microsecond precision, but does not include a time zone. (The stored timestamp is always kept in UTC.)

Related questions

How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More
How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More
MySQL error code: 1175 during UPDATE in MySQL Workbench

I'm trying to update the column visited to give it the value 1. I use MySQL workbench, and I'm writing the statement in the SQL editor from inside the workbench. I'm writing the following command: UPDATE tablename SET columnname=1; It gives …

Read More