Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Date commands
Message
De
01/06/2005 14:57:46
 
 
À
01/06/2005 14:48:45
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 7 SP1
Divers
Thread ID:
01019078
Message ID:
01019085
Vues:
22
>Hello,
>I have a date that I am reading from SQL Server, and I want to test to see if it is at least 30 minutes in the past. How would I do this?
IF SQLDateTime+(30*60)>=DATETIME()
  * Less than 30 minutes ago
ELSE
  * more than 30 minutes ago
ENDIF
Update:
This assumes that your PC and the server that stored the SQL data (and how the time was stored) are in sync with each other.
Fred
Microsoft Visual FoxPro MVP

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

Click here to load this message in the networking platform