I'm building an application for scheduling employees in a department.
For the datetime-related dtaa , is their a "best practice" for the data
storage? For example, in building a schedule table, I need the date
portion for the column headers (days of the week) and I need the hour
portion for the rows. I am currently storing datetime data as mm-dd-yyy
hh:mm:ss. I seem to be always having trouble gettign the date to p
correctly and to build the correct SELECT statements to retrieve the
right data. Is it better to just store the data in a unix-style format?