topic-43465

Board index FiveWin for Harbour/xHarbour ODBC Date Format

Posts: 1772

Joined: Thu Sep 05, 2019 05:32 AM

ODBC Date Format
Posted: Mon Jul 17, 2023 11:52 AM

hi,

i notice that Sample c:\fwh\samples\testodbc.prg show DATE as YYYY-DD-MM
i have SET DATE GERMAN but it does not help

how to use ODBC and GERMAN Date Format :?:

greeting,

Jimmy

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: ODBC Date Format
Posted: Tue Jul 18, 2023 06:27 AM

That is a character value
You con covert to date with

Code (fw): Select all Collapse

dDate := FW_Str2Dt( strDate )

Please see:

Code (fw): Select all Collapse

   oDbf:lDateAsStr := .t.

at line 95 of testodbc.prg

Regards

G. N. Rao.

Hyderabad, India

Jimmy

Posts: 1772

Joined: Thu Sep 05, 2019 05:32 AM

Re: ODBC Date Format
Posted: Tue Jul 18, 2023 08:48 PM

hi,

nageswaragunupudi wrote:That is a character value

Please see:
Code (fw): Select all Collapse
      oDbf:lDateAsStr := .t.
at line 95 of testodbc.prg

ok, thx

when set .F. and use SET DATE GERMAN it display right

greeting,

Jimmy

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: ODBC Date Format
Posted: Tue Jul 18, 2023 09:10 PM

I don't know.

Haven't touched ODBC for a very long time.

Regards

G. N. Rao.

Hyderabad, India

FiveTech Support Forums

Continue the discussion