date type fields

[JonathanHolliday]

Hi,

The system we are using has a unique date identifier rather than using a recognised date format.

I need to convert this date into a "DATE" format field so that the reporting tool (Business Objects) can work with it.

I tried to create a lookup table with a field 'date' in it using the below sql but it hasn't worked. The table creates but in CSQL the field name is missing and the field shows as no characters []. The record length appears to suggest that four characters are assigned for the date field.

CREATE TABLE wf_caldate (
caldate CHAR(7),
datedesc CHAR(20),
date DATE
) IN "/data/copylive/wf-caldate";

CREATE UNIQUE INDEX wf_caldate0 ON wf_caldate (caldate);

Does anyone know how to create a table with a date field in it, also what format the data would need to be in to populate the table.

 

[PHV]

Take a look at the DBDATE environment variable in your manual.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884