Datetime fields in MSSQL as Date in VFP

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Datetime fields in MSSQL as Date in VFP

Message

08/12/2009 00:46:18

07/12/2009 17:44:04

Information générale

Forum:

Visual FoxPro

Catégorie:

Client/serveur

Titre:

Versions des environnements

Visual FoxPro:

VFP 9 SP2

OS:

Windows XP SP2

Network:

Windows 2003 Server

Database:

MS SQL Server

Application:

Desktop

Divers

Thread ID:

01437969

Message ID:

01438007

Vues:

Using SQL Server 2008, SQL Server Native Client 10.0 and T-SQL this works for me:

select cast(datetimefield as DATE) as dateonly from mytable

Brandon Harker
Sebae Data Solutions