| Subject | OT Pros & Cons of TimeStamp field VS Date field and Time field |
|---|---|
| Author | gsbrown@GerBreOwn.com |
| Post date | 2001-07-20T11:54:04Z |
Does anyone know what the advantages/disadvantages of using a
TimeStamp field in a table as opposed to using a Date field and a Time
field.
One advantage of the TimeStamp that I see is having to update only one
field as opposed to 2.
Would it be faster/slower to search for a specified date in either
type of data field?
TIA
Gerald S. Brown
TimeStamp field in a table as opposed to using a Date field and a Time
field.
One advantage of the TimeStamp that I see is having to update only one
field as opposed to 2.
Would it be faster/slower to search for a specified date in either
type of data field?
TIA
Gerald S. Brown