Why do some date fields have DataType D(8) instead of DataType D?

[Peter]

I'm looking at the SQL statement of a remoteview to a SQL Server table
through View SQL of the View Designer and the prg generated from gendbc. I
notice that some Date fields are showing having DataType D or DataType
D(8). What is the difference between DataType D and DataType D(8)?

Thanks.

[Rick Bean]

Peter,
I'm not sure about the designations, but MS SQL Server has no Date (D) field type only DateTime (T).

Rick

Post by Peter
I'm looking at the SQL statement of a remoteview to a SQL Server table
through View SQL of the View Designer and the prg generated from gendbc. I
notice that some Date fields are showing having DataType D or DataType
D(8). What is the difference between DataType D and DataType D(8)?
Thanks.

[Peter]

Hi Rick,

I know that SQL Server has DateTime only. I did the following steps to
duplicate this:

1. Enlarge one of the char column of the SQL Server table
2. Modify the property Width of that column in the remote view to match
with the column size.
3. Save the remote view.
4. Open the remote view and check the SQL statement and find all the date
fields which used to have DataType D(8) becomes DataType D.

Post by Rick Bean
Peter,
I'm not sure about the designations, but MS SQL Server has no Date (D) field type only DateTime (T).
Rick

Post by Peter
I'm looking at the SQL statement of a remoteview to a SQL Server table
through View SQL of the View Designer and the prg generated from gendbc. I
notice that some Date fields are showing having DataType D or DataType
D(8). What is the difference between DataType D and DataType D(8)?
Thanks.