Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Hour from datetime
Message
From
12/11/2013 12:31:32
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Hour from datetime
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01587834
Message ID:
01587834
Views:
95
the following code in a SQL interrogation always return "0-12"
IIF( (HOUR( TTOD( Table1.datecreation)) >=0  AND HOUR( TTOD( Table1.datecreation)) <= 11), "0-12", IIF( (HOUR( TTOD( Table1.datecreation)) >= 12 AND HOUR( TTOD( Table1.datecreation)) <= 15), "12-16", "16-24")) as HourBlock
Data contains hours in all the range 0-24. So I should have some "12-16" and "16-24"

You guys see something that I don't?
*******************************************************
Save a tree, eat a beaver.
Denis Chassé
Next
Reply
Map
View

Click here to load this message in the networking platform