Skip to main content
Database Administrators

Return to Question

added timestamp tag
Source Link
Nick Chammas
Nick Chammas
  • 14.8k
  • 17
  • 76
  • 123

What is the difference between datetime and timestamp in mysqlMySQL with respect to data being inserted from different timezones. Does? Does anyone have any clues on this, i?

I have a situation where iI am trying to migrate from db2 to mysql.In In DB2 a field is referred to as timestamp but mysql'sMySQL's timestamp does not support values greater than 2038-01-19 03:14:07, so iI have used datetime. Before implementing datetime iI want to do an impact analysis.

What is the difference between datetime and timestamp in mysql with respect to data being inserted from different timezones. Does anyone have any clues on this, i have a situation where i am trying to migrate from db2 to mysql.In DB2 a field is referred as timestamp but mysql's timestamp does not support values greater than 2038-01-19 03:14:07, so i have used datetime. Before implementing datetime i want to do an impact analysis.

What is the difference between datetime and timestamp in MySQL with respect to data being inserted from different timezones? Does anyone have any clues on this?

I have a situation where I am trying to migrate from db2 to mysql. In DB2 a field is referred to as timestamp but MySQL's timestamp does not support values greater than 2038-01-19 03:14:07, so I have used datetime. Before implementing datetime I want to do an impact analysis.

added timestamp tag
Link
edit approved May 14, 2013 at 11:23
altmannmarcelo
edit approved May 14, 2013 at 11:23
altmannmarcelo
  • 1.2k
  • 8
  • 26
Source Link
Hitesh Chouhan
Hitesh Chouhan
  • 507
  • 5
  • 12
  • 22

datetime vs timestamp in mysql 5.5

What is the difference between datetime and timestamp in mysql with respect to data being inserted from different timezones. Does anyone have any clues on this, i have a situation where i am trying to migrate from db2 to mysql.In DB2 a field is referred as timestamp but mysql's timestamp does not support values greater than 2038-01-19 03:14:07, so i have used datetime. Before implementing datetime i want to do an impact analysis.