Dear all,
we have a project where a statistic database is build up and the
statistics should be exported to Excel sheets.
The database stores e. g. job opening dates and times. These fields are
used more or less always to select data, for
- jobs in one month
- jobs between 10:00 hrs and 14:00 hrs a day
- ...
What is the best data type to store the date/timestamps.
I see three alternatives:
1. separate DATE and TIME fields
2. TIMESTAMP field
3. FIXED(18,12) field
Is there a hint which is the best concerning performance when accessing
via an index?
Thanks and
best regards
Hannes
--
Hannes Degenhart GPS - Gesellschaft zur Pruefung von Software mbH
Hoervelsinger Weg 54 D - 89081 Ulm - Germany
Pho. +49 731 96657 14 Fax. +49 731 96657 57
mailto:[EMAIL PROTECTED] Web: http://www.gps-ulm.de
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
