Hi,

I'm sure i just missed it in the manual - but is there a way to select the time field (via sql select) into a 24 hour format? (instead of 12 hour AM/PM)?

Regards
Danie

Danie,

<< I'm sure i just missed it in the manual - but is there a way to select
the time field (via sql select) into a 24 hour format? (instead of 12 hour
AM/PM)? >>

Do you want to do this formatting as part of the query itself ?  If so, then
just use the CAST() function (it always uses a 24-hour representation for
time values cast as strings):

SELECT CAST(MyTimeField AS VARCHAR(20)) FROM MyTable

If you want to do it at the TField level of the TDBISAMQuery, you can use
the DisplayFormat property:

MyDBISAMQuery.Open;
MyDBISAMQuery.FieldByName('MyTimeField').DisplayFormat:='h:nn:ss';

Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim,

thank you

This

"SELECT CAST(MyTimeField AS VARCHAR(20)) FROM MyTable"

is what I was looking for. Should have tried it before asking. Thanks again.

Danie