OraFAQ Forum: MySQL » Difference between DATETIME and TIMESTANP

Home » Open Source » MySQL » Difference between DATETIME and TIMESTANP (MySql)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Difference between DATETIME and TIMESTANP [message #656243]

Fri, 30 September 2016 02:44

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?

Report message to a moderator

Re: Difference between DATETIME and TIMESTANP [message #656245 is a reply to message #656243]

Fri, 30 September 2016 03:13

ThomasG
Messages: 3212
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.

Report message to a moderator

Re: Difference between DATETIME and TIMESTANP [message #656249 is a reply to message #656245]

Fri, 30 September 2016 04:38

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

Re: Difference between DATETIME and TIMESTANP [message #656273 is a reply to message #656243]

Fri, 30 September 2016 18:04

Barbara Boehmer
Messages: 9106
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

Report message to a moderator

Re: Difference between DATETIME and TIMESTANP [message #656315 is a reply to message #656273]

Mon, 03 October 2016 02:37

Cathydoesloans
Messages: 2
Registered: September 2016

Junior Member

Thank you for the description and link, I'll check it !

Report message to a moderator

Previous Topic:	getting output as per String content
Next Topic:	select statement as per the columns label

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 20 00:57:35 CST 2026