If you are using the timestamp column type, it will not ignore the hour minutes seconds when creating or updating a record.
however, you don't need to use them on the pages that you display the date. When displaying the date from the database on your page using a recordset, you can strip the hours minutes seconds part using the date function, for example:
[php]<?php echo(date("Y-m-d", strtotime($row_RecordsetName['ColumnName']))); ?>[php]
the other option would be to use the Date column type instead of using timestamp. The draw back to this is that the Date column type does not support using a default value to automatically set the date when a record is created.