🚀 go-pugleaf

"Edward Diener" <eddielee@tropicsoft.com> wrote in message
news:3dea8c42@newsgroups.borland.com...
>
> One of the problems is that sequence, at least as far as the date value,
is
> concerned, is locale dependent. In the US the dates are MM-DD-YY. So how
> does one know which format to use ?

Interbase always accepts the same set of formats no matter what anyone's
local settings may be.

I have searched for the SQL format for
> DATE, TIME, and TIMESTAMP for Interbase in the docs to no avail. But this
> seems par for the Interbase docs, which are terrible. No wonder Borland
has
> had such a hard time selling Interbase to customers.

Embedded SQL guide, page 182:

Formatting dates for input
Dates for input as datatype DATE can have any of the following forms:
YYYYpMMpDD
MMpDDpYYYY
DDpMMpYYYY
YYpMMpDD
MMpDDpYY
DDpMMpYY
where:
DD = one- or two-digit day
MM = one- or two-digit month,
or a three-letter month abbreviation,
or the full English month name (case does not matter)
YY = last two digits of a year
YYYY = four-digit year
p = any ASCII punctuation character; extra whitespace (tabs or spaces) is
ignored

... there is a whole lot more information here.


--
Wayne Niddery (Logic Fundamentals, Inc.)
RADBooks: http://www.logicfundamentals.com/RADBooks/delphibooks.html
It used to be that other people's achievements were considered an
inspiration, not a grievance.