Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Check for dates
Message
De
01/07/2003 15:38:20
 
 
À
30/06/2003 18:11:21
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Divers
Thread ID:
00805497
Message ID:
00805797
Vues:
39
>What technique do you guys use to check for a date range in SQL2000?
>
>Let's say I want to bring records between 1/1/2003 and 1/10/2003? What Transact SQL (not foxpro syntax) syntax would you use to bring back those records? I'm using sql passthru.
>
>Thanks

I just use the format returned from DTOS(). That seems to work fine for SQL2000.

SELECT * FROM table WHERE datetimefield BETWEEN '20030101' AND '20030110'
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform