topic-27721

Board index FiveWin for Harbour/xHarbour convert datetime MySQL into Date DBF

elvira

Posts: 518

Joined: Fri Jun 29, 2012 12:49 PM

convert datetime MySQL into Date DBF
Posted: Mon Nov 25, 2013 07:39 PM

Hello,

What is the function to convert datetime MySQL into Date field DBF?.

Thanks!.

shri_fwh

Posts: 336

Joined: Mon Dec 07, 2009 02:49 PM

Re: convert datetime MySQL into Date DBF
Posted: Mon Nov 25, 2013 09:44 PM

Hi ,

If you are using TDolphin Lib then you do not need convert MySql Date into Harbour Date Type. However you can also use below function to convert any data type to corresponding Harbour Data Type.

Code (fw): Select all Collapse

HB_FUNC( SQL2CLIPTYPE )
{
  hb_retc( SQL2ClipType( hb_parnl( 1 ), hb_parl( 2 ) ) );
}

Thanks
Shridhar

Thanks

Shridhar

FWH 24.04, BCC 7 32 bit, MariaDB

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: convert datetime MySQL into Date DBF
Posted: Mon Nov 25, 2013 11:08 PM

elvira wrote:Hello,

What is the function to convert datetime MySQL into Date field DBF?.

Thanks!.

FW_TToD( tDateTime/dDate ) --> dDatePart // ValType D
FW_DToT( tDateTime/dDate ) --> tDateTime // ValType T

Regards

G. N. Rao.

Hyderabad, India

FiveTech Support Forums

Continue the discussion