Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date\Time or datetime
Message
From
29/06/2009 10:20:30
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Date\Time or datetime
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01409057
Message ID:
01409057
Views:
107
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
Thank you
Chaim
Next
Reply
Map
View

Click here to load this message in the networking platform