>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.
OffThere is no place like [::1]