Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date\Time or datetime
Message
From
29/06/2009 12:31:07
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
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:
01409105
Views:
37
Thank you
>>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
>
>If you need a date range, you can use
>
>MyDateTimeField >=StartDateParam and myDateTimeField < EndDateParam + 1
Thank you
Chaim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform