Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Datetime Conversion
Message
 
 
To
12/02/2019 00:10:37
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 10
Network:
Windows 2008 Server
Database:
MS SQL Server CE
Application:
Desktop
Miscellaneous
Thread ID:
01666300
Message ID:
01666302
Views:
42
Why not use DATEDIFF() ?

>Sir, while using SQLSERVER 2008, I have these codes
>
>
>
>UPDATE bin1 SET delay_int =
>(select replace(replace(replace(CONVERT(VARCHAR(19), DATE, 120),'-',''),' ',''),':','')as int)
>-(select max(replace(replace(replace(CONVERT(VARCHAR(19), DATE, 120),'-',''),' ',''),':',''))as int
>   FROM bin1 j1
>  WHERE j1.date < bin1.date)
>
>
>but is showing this error message
>
>
>
>and here is table structure
>
>
>
>
>Actually I am converting date stamp to INT then subtract.
>
>Please help me how to make query workable?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform