I will keep date in seperate column with date datatype as well as a part of primary key.