Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TimeStamps calculating differently
Message
From
16/08/2007 08:26:02
 
 
To
15/08/2007 11:10:02
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01248245
Message ID:
01248466
Views:
23
>Never search like this:
>
>
select * from myTable where myDatetime = m.ltDatetime
>
>But like this:
>
>
select * from myTable where ttoc(myDatetime,1) == ttoc(m.ltDatetime,1)
>
>or a similar expression.
>Cetin

When > < Between() is it also better to use ttoc()? Like ttoc(myDatetime,1) >= ttoc(m.ltDatetime,1)

Kamil
A moment of silence is our cosmic reset button.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform