RE: Storing a year in an sql database
- From: "Rodney Haynie" <RHaynie@xxxxxxxxxxx>
- To: <programmingblind@xxxxxxxxxxxxx>
- Date: Fri, 8 Aug 2008 12:52:29 -0400
Personally I would store it numerically in a 4 digit format. So this year
would be stored as 2008.
I assume you do not need to know the month, day, or time.
In mysql I would choose the SmallInt datatype.
HTH.
Rodney
-----Original Message-----
From: programmingblind-bounce@xxxxxxxxxxxxx
[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Sean Farrow
Sent: Thursday, August 07, 2008 7:00 PM
To: programmingblind@xxxxxxxxxxxxx
Subject: Storing a year in an sql database
Hi:
What is the best way of storing a year in an sql database.
Any help apreciated.
Sean.
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 3338 (20080807) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
Other related posts:
