Skip navigation links

MySQL Forums :: Performance :: Timestamp vs Datetime


Advanced Search

Re: Timestamp vs Datetime
Posted by: Erin ONeill ()
Date: July 18, 2005 04:51PM

I've been in the same quandry. Our production server is 4.0. I'm pushing to update to at least 4.1. In combing thru the schema I've been forced to do a lot of reading on datetime vs timestamp. And the conclusion I've come to is to use datetime for everything BUT the last_modified field. The reason for that is we want to continue to use this syntax in the CREATE TABLE code:
last_modified timestamp default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP

As far as I've read you can not use something like NOW() with datetime.... If I'm wrong I want to hear! :)

erin

Options: ReplyQuote


Subject Views Written By Posted
Timestamp vs Datetime 83420 Tom Dean 07/17/2005 05:33PM
Re: Timestamp vs Datetime 45690 Benoit St-Jean 07/17/2005 09:37PM
Re: Timestamp vs Datetime 30712 Erin ONeill 07/18/2005 04:51PM
Re: Timestamp vs Datetime 23143 Allen Arakaki 07/21/2005 05:36PM
Re: Timestamp vs Datetime 54727 Allen Arakaki 07/21/2005 05:59PM
Re: Timestamp vs Datetime 22910 Erin ONeill 07/22/2005 11:41AM
Re: Timestamp vs Datetime 15046 Erick Papadakis 11/21/2006 01:28PM
Re: Timestamp vs Datetime 14594 KimSeong Loh 11/21/2006 05:55PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.