[Zope] date in Z Gadfly Database
Angietel
angietel@hotmail.com
Thu, 23 Nov 2000 16:16:14 +0800
This is a multi-part message in MIME format.
------=_NextPart_000_0013_01C05568.B3E71700
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
When i create a table, one of the fields is consider as date type, but =
the Z Gadfly Database does not allow me to do that, it only accepts =
INTEGER instead of DATE type.
The following is my SQL for creating a table:-
CREATE TABLE customer
(custid VARCHAR(10),
custname VARCHAR(15),
custactdate DATE,
custadd1 VARCHAR(30),
custadd2 VARCHAR(30))
Please let me know if i got an error.Thank You.
------=_NextPart_000_0013_01C05568.B3E71700
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>When i create a table, one of the =
fields is=20
consider as date type, but the Z Gadfly Database does not allow me to do =
that,=20
it only accepts INTEGER instead of DATE type.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>The following is my SQL for creating a=20
table:-</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>CREATE TABLE customer<BR>(custid=20
VARCHAR(10),<BR>custname VARCHAR(15),<BR>custactdate DATE,<BR>custadd1=20
VARCHAR(30),<BR>custadd2 VARCHAR(30))<BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Please let me know if i got an =
error.Thank=20
You.</DIV></FONT></BODY></HTML>
------=_NextPart_000_0013_01C05568.B3E71700--