Which one of the following is preferably used when creating an attribute containing data on when something was established:
- "String"
- "Text"
- "Date"
- "Date/Time"
?
Researching, I found that both "String" and "Date" should be able to create "(YYYY-MM-DD)" equally well.
I also found earlier posts here on SO with titles like this one: How to convert date(string type) into date(date time ) in oracle
Obviously there's a point I've missed here. Surely there's a benefit for using one over the other.
(I'm working in MDriven)
Many thanks.