在mysql中更改日期时间设置 [英] Change Datetime settings in mysql

问题描述

在将mssql迁移到mysql时，我得到日期时间格式问题，任何人都可以告诉如何在mysql中更改日期时间格式。







提前致谢

Hi,

While migrating mssql to mysql i am getting datetime format problem can any one tell how to change datetime format in mysql.



Thanks in advance

推荐答案

DATETIME值don' t有一种格式：它们从任意时间点开始存储为毫秒数。



所以你需要看一下你要插入什么，更新，或者在查询或外部代码中选择您的值。



获取日期格式问题的最常见原因是您在外部连接字符串用于形成SQL查询的代码 - 这非常危险，并且在使用INSERT或UPDATE时容易出错。

DATETIME values don't have a format: they are stored as a number of milliseconds since an arbitrary point in time.

So you need to look at what you are doing to insert, update, or select your values in either a query or your external code.

The most common reason for getting "format" problems with dates is that you are concatenating strings in external code to form SQL queries - which is extremely dangerous as well as prone to errors when INSERT or UPDATE is used.

这篇关于在mysql中更改日期时间设置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！