BTW. Using DATE and TIME as column names is a poor practice (They are reserved words in most database server or programming language...)
Second; why not combine the date and time in ONE field? You can easily separate the date/time as needed for display, and it's easier to perform date 'arithmetic' with a single field.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert