23 Nov
2000
23 Nov
'00
8:16 a.m.
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.