If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Would this query make any sense if I were to add a column "Birthday" with date data type?

ALTER TABLE Dogs
ADD Birthday number(4);

Thanks a lot.

c360

Would the 4 be just a year? Since this is for dogs, maybe just a year would suffice. If you need the full date, best to use the date datatype whenever possible. Depends on what you need for your queries/reports