I use PHP / MySQL, and I always used DATETIME to store values createdand updated, but I think there might be a better way.
created
updated
Should I use TIMESTAMP instead, and if so, why?
The documentation states:
TIMESTAMP UTC UTC . ( TIMESTAMP, , DATETIME.) - . , 9.6 " MySQL". , , . TIMESTAMP, , . , . time_zone.
, TIMESTAMP, , / UTC, .
TIMESTAMP
UTC . , , , , . , .
Source: https://habr.com/ru/post/1774713/More articles:How does the active application terminate when the battery runs out on the iOS device and shuts down? - iphoneJavascript global variables - javascriptLIFO Single Artist / SwingWorker - javaWhere can I find Python code examples or tutorials for social network style features / components? - pythonJava.charAt (i) comparison problem - javaXNA: a project to reuse content in another project within the same solution - xnaИзвлечь информацию о цвете из ggplot2? - colorsAre there simulation environments for UAVs? - roboticsHow to find downtime (and network entry time, etc.) in XPerf? - optimizationSQL NOW () gives 0000-00-00 00:00:00 - typesAll Articles