List:General Discussion« Previous MessageNext Message »
From:Jigal van Hemert Date:April 5 2005 2:39pm
Subject:Re: dateTime vrs. Timestamp
View as plain text  
From: "DePhillips, Michael P"
> Am I gaining anything by using a timestamp instead of using dateTime and
> calling now(), for example, increased performance, better indexing, etc.
> I guess another way to ask this is does the MySQL internals handle a
> timestamp more efficiently than a dateTime.

I haven't seen much difference in performance; in fact I think you'll lose
standard human readable output (I still can't read UNIX timestamps), you'll
lose a large range of dates, etc.

You'll probably gain more by optimizing the query and expressions, designing
the right indexes, etc.

Regards, Jigal.

dateTime vrs. TimestampMichael P DePhillips5 Apr
  • RE: dateTime vrs. TimestampJ.R. Bullington5 Apr
  • Re: dateTime vrs. TimestampJigal van Hemert5 Apr