Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Last 2 minutes Data
Message
De
22/01/2019 03:30:28
Lutz Scheffler (En ligne)
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
À
22/01/2019 02:59:16
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01665598
Message ID:
01665600
Vues:
76
>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

I'm not into SQL Server but I guess your logic is the wrong way

The time you search is larger then 2 minutes ago. So in VFP pseudocode
SELECT .. WHERE dDateTime>DATETIME()-120
Pro tip:
Do not be that lazy and paste sceeenshots. Add code snippets out of characters.
I can't look into pictures while doing the reply, nor can I copy it.


Lutz
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform