create attendance system
i will create attendance system , i have some questions
1- i have a column that has data like 1/1/2014 07:59:53 the datatype for this column in database is date in form i put a format for this field to appear in database 1/1/2014 07:59:53 or not ?
2- i have a column in time table that start from 08:00 and end at 16:00 what is the datatype is varchar2(5) but when the user enter in this field i want to force him to enter 08:00 how i do this ?