Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INDEX ON DateTime Field?
Message
From
27/10/1998 11:58:08
 
 
To
27/10/1998 09:36:02
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00150884
Message ID:
00151071
Views:
27
Interesting. In 5.0aw/sp3, I tried this and some variations, too.

x={^1998/10/27 08:30:00 A}
SELECT * FROM c_tbl WHERE x = dt_tm && This selects the correct record
SELECT * FROM c_tbl WHERE dt_tm = x && This results in an empty data set.

>SELECT * FROM c_tbl WHERE dt_tm = {^1998/10/27 08:30:00 A}
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform