What datatype should i use for year?

poopsy

New Member

Join Date: Nov 2006

Posts: 50
#1

What datatype should i use for year?

Mar 14 '08, 11:24 AM

hi..i am creating a table where i have a file "year", wat datatype shud i use as i only want the year and not the full date
Tags: None
rski

Recognized Expert Contributor

Join Date: Dec 2006

Posts: 700
#2

Mar 14 '08, 12:33 PM

Originally posted by poopsy

hi..i am creating a table where i have a file "year", wat datatype shud i use as i only want the year and not the full date

If you mean "column year" you can use any of numerc datatypes (numeric, int,...) see all at postgresql.org
Comment

Comment