RE: dateTime vrs. Timestamp

2005-04-05 Thread J.R. Bullington
IMO, dateTime doesn't parse now() the same way that timeStamp does. If you use now() in a dateTime field, I have found that it doesn't always write the time to the record, while using now() with the timestamp always does. As far as your other questions, the indexing and increased performance, I

Re: dateTime vrs. Timestamp

2005-04-05 Thread Jigal van Hemert
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