Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Number or Character for Year

Number or Character for Year

From: <nboemio_at_my-dejanews.com>
Date: 1998/06/09
Message-ID: <6lj9b7$c7k$1@nnrp1.dejanews.com>#1/1

When storing a year in a table, is there any preference between using NUMBER(4) or VARCHAR2(4)?

And I mean as a general convention throughout the database and not for a specific table.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Jun 09 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US