Information générale
Forum:
Microsoft SQL Server
Titre:
Date data type is converted to character by vfp?
Versions des environnements
SQL Server:
SQL Server 2008
I read that the date data type was added to sql server in server 2008. For the following statement:
lnr=sqlexec(lnh,"select cast(dt_date as date) as date_ from activity","curactivity")
dt_date is a datetime data type. In the cursor curactivity, date_ become character (10), not vfp's data type date.
Is there anyway to directly convert this this vfp's date datatype?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement