🚀 go-pugleaf

On Mon, 11 Jan 1999 20:05:42 +0100, tt <thomas@trautwein.com> wrote:

>rick ,
>thanks for answering.
>dtos() unfortunately does not work, local sql does not offer this function.

There is no function in SQL (or local SQL) equivalent to the dBASE DTOS
function. The closest single function is CAST, which can convert a DATE or
DATETIME value to CHAR -- but in the format MM/DD/YY. The DTOS function
would convert to string in the format YYYYMMDD. To get the effects of DTOS
in a local SQL statement, you would need to use combinations of EXTRACT and
CAST, concatenating the values together in the order you desire. Another
post in this thread describes this.

//////////////////////////////////////////////////////////////////////////
Steve Koterski                      "I do most of my writing sitting down.
Technical Publications              That's where I shine."
INPRISE Corporation                         -- Robert Benchley (1889-1945)
http://www.inprise.com/delphi