Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Date\Time or datetime
Message
 
 
À
29/06/2009 10:20:30
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01409057
Message ID:
01409061
Vues:
53
>Hi
>Help please,
>
>One field of datetime or two fields, one for date and one for time?
>
>My client goal is to type&retrieve when to call back to customer (for example another 2 minuts, 30 minuts, another three days 18:00 PM etc)
>I have to retrieve data with queries by date, by time (next half hour) etc
>In addition by combination of date\time range and priority and to order by few options.
>
>I know something abut converting from datetime to dateand time and opposite, but what is better?
>
>Tnk

I would use Datetime field (one field) and perform conversions as necessary - should not be hard.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform