Home » Open Source » MySQL » Difference between DATETIME and TIMESTANP (MySql)
Difference between DATETIME and TIMESTANP [message #656243] Fri, 30 September 2016 02:44 Go to next message
Cathydoesloans
Messages: 2
Registered: September 2016
Junior Member
Who can help me what is difference between DATETIME and TIMESTAMP and is what cases do i need to use each other?
Re: Difference between DATETIME and TIMESTANP [message #656245 is a reply to message #656243] Fri, 30 September 2016 03:13 Go to previous messageGo to next message
ThomasG
Messages: 3205
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
The main difference in Oracle is that "TIMESTAMP" does exist, but there is nothing that is called "DATETIME" in Oracle.
Re: Difference between DATETIME and TIMESTANP [message #656249 is a reply to message #656245] Fri, 30 September 2016 04:38 Go to previous messageGo to next message
Michel Cadot
Messages: 65254
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The question is for MySQL, I move the topic to this forum.

Re: Difference between DATETIME and TIMESTANP [message #656273 is a reply to message #656243] Fri, 30 September 2016 18:04 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8779
Registered: November 2002
Location: California, USA
Senior Member
The two types have different value ranges. Timestamp stores fractions of seconds and datetime does not. So, which you use depends on what you need. The following online manual section describes the types and their differences in more detail. Just click on the link below.


http://dev.mysql.com/doc/refman/5.7/en/datetime.html
Re: Difference between DATETIME and TIMESTANP [message #656315 is a reply to message #656273] Mon, 03 October 2016 02:37 Go to previous message
Cathydoesloans
Messages: 2
Registered: September 2016
Junior Member
Thank you for the description and link, I'll check it !
Previous Topic: getting output as per String content
Next Topic: select statement as per the columns label
Goto Forum:
  


Current Time: Thu Dec 14 12:44:59 CST 2017

Total time taken to generate the page: 0.01390 seconds