This is a multipart message in MIME format.
------=_NextPart_000_002B_01C8AED4.9AC9DF00
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Hi all,
I am building an application which requires the storage of dates relating
to
the creation of archaeological items. The problem I am facing is that
although most of the dates are working fine, some of the items were
created
before the beginning of recorded history (4713 BC).
Does anyone have any suggestions for making these dates play nicely with
items created more recently (January 10th, 1968 for example)? My only
other
requirement is that I need to be able to execute SQL queries which can
find
items made before a certain date, after a certain date, or between two
dates.
Cheers,
Ryan
------=_NextPart_000_002B_01C8AED4.9AC9DF00
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml"
=
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@[EMAIL PROTECTED]
"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@[EMAIL PROTECTED]
15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
..MsoChpDefault
{mso-style-type:ex****t-only;}
@[EMAIL PROTECTED]
Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal>Hi all,<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>I am building an application which requires the =
storage of
dates relating to the creation of archaeological items. The problem I am =
facing
is that although most of the dates are working fine, some of the items =
were
created before the beginning of recorded history (4713 BC). =
<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Does anyone have any suggestions for making these =
dates play
nicely with items created more recently (January 10<sup>th</sup>, 1968 =
for
example)? My only other requirement is that I need to be able to execute =
SQL
queries which can find items made before a certain date, after a certain =
date,
or between two dates.<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Cheers,<o:p></o:p></p>
<p class=3DMsoNormal>Ryan<o:p></o:p></p>
</div>
</body>
</html>
------=_NextPart_000_002B_01C8AED4.9AC9DF00--
|
