[archive] acu4GL/SQL SERVER2008 Express, DATE issue

[Migrated content. Thread originally posted on 27 August 2010]

I define the MY-DATE as below in my xfd file, and I create the table in SSE2008

$XFD USE GROUP, DATE=YYYYMMDD
05 MY-DATE.
10 MY-YYYY PIC 9(4).
10 MY-MM PIC 9(2).
10 MY-DD PIC 9(2).

and I give it value "2010-08-27"
I would like to see them stored in SSE2008 as
"2010-08-27" or say I would like to create this field as "Date" rather than "Datetime".

But actually I got this value
"2010-04-26 00:00:00.000"

How could I solve this issue? Any ideas?

I guess I should use some special parameter in this line, but I didn't see any hint on acu811 hepl document.
$XFD USE GROUP, DATE=YYYYMMDD

Thanks.