Subject | Date conversion |
---|---|
Author | Christian Gütter |
Post date | 2000-12-28T00:37:52Z |
Hi,
I am trying to populate the where clause of an
TIB_Query with dates which are returned by a
TDateTimePicker.
The date format in my country is mostly DD.MM.YY
or DD.MM.YYYY (and the DateTimePicker returns the
dates in this format).
Unfortunately, IB doesn't accept these date formats
in my select statement.
So I wonder how I can convert these dates to the format
IB will accept.
There must be a routine which serves this purpose, but
I can't find it.
Can anyone point me into the right direction?
TIA,
C.
I am trying to populate the where clause of an
TIB_Query with dates which are returned by a
TDateTimePicker.
The date format in my country is mostly DD.MM.YY
or DD.MM.YYYY (and the DateTimePicker returns the
dates in this format).
Unfortunately, IB doesn't accept these date formats
in my select statement.
So I wonder how I can convert these dates to the format
IB will accept.
There must be a routine which serves this purpose, but
I can't find it.
Can anyone point me into the right direction?
TIA,
C.