>1.can i do that as qdate d(8).

qDate d && Date field
tDate t && DateTime field



>hi,
>thank you very much,
>YES qdate C(30) , date type
>1.can i do that as qdate d(8).
>2. if this field have date and time how i can identfy the type.
>
>sorry for boor English language.
>
>>>hi all,
>>>
>>>i try to create table , some fields as number(numaric)TYPE
>>>

>>> CREATE TABLE home(list_no N(10), customer_tel C(15),name C(80), area_no C(10),account C(10), qdate C(30),home C(10), bus C(40),survey_no c(10), flag N(10),n_try N(10)  NOCPTRANS)
>>>

>>>THANKS
>>
>>Use the NOCPTRANS keyword after each character fields where you need, it has no meaning for a numeric field like you have used it.

>>CREATE TABLE home (list_no N(10), cust_tel C(15) nocp ,name C(80) nocp, area_no C(10) nocp ,account C(10), qdate C(30) nocp,home C(10) nocp, bus C(40) nocp,survey_no c(10) nocp, flag N(10),n_try N(10))

>>And note that customer_tel is more than 10 character, and NOT a legal fieldname in a free table.
>>Also if qdate is a date, you should use a date field type!!!