Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Last 2 minutes Data
Message
From
22/01/2019 02:59:16
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Last 2 minutes Data
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01665598
Message ID:
01665598
Views:
65
Sir while using sqlserver 2008, I have this data



Suppose current time is

2019-01-22 10:33:00

I want to get Data of last 2 MINUTES as

15 2019-01-22 10:31:46.287 25
16 2019-01-22 10:32:13.677 35

I used these codes




but it is showing wrong result.


Please
Next
Reply
Map
View

Click here to load this message in the networking platform