🚀 go-pugleaf

Thomas,

I assume your data is in dBASE tables.

It should be like this:

SELECT field1, field2, CAST( dateField AS CHAR( 10 ) ) FROM yourTable

I, however, found that the resulting dates have 2 digits only for the
year (YY) instead of 4 (YYYY). I am not sure how to get around that
unless you do something much longer like this:

SELECT field1, field2, CAST( EXTRACT( YEAR FROM dateField ) AS CHAR( 4 )
)  || CAST( EXTRACT( MONTH FROM dateField ) AS CHAR( 2 ) )  || CAST(
EXTRACT( DAY FROM dateField ) AS CHAR( 2 ) ) FROM yourTable

This results in YYYYMMDD, except that single digit MMs or DDs have no
leading zero (so, for example, 9 December 1998 comes out as 1998129 and
not 19981209). There is a way to do that, too, but I don't have an SQL
reference at hand.

Failing all that, you could use the dBASE calculated field instead of
these SQL calculated fields. See the online help for CLASS FIELD on how
to do that.

--
Geoff Wass
Kuala Lumpur, Malaysia


=>=> More dBASE info at http://members.theglobe.com/Geoff_Wass <=<=