Data Type Date

[Patricia Samuel]

Hi Experts,

I am working on creating table structure for my application. There are some date fields that would not have time with them in the data. I want to ask you guys whether we should take Date date type for this type of column or we should prefer Varchar2.

Thanks for all your help in advance!!!

Warm Regards,
Patricia samuel

[Agador Paloi]

Always use Date for dates regardless if you are interested in the time or not.

Agad