css动态背景图像定位(css dynamic background image positioning)

 如果您对自己的格式保持一致有信心，那么您可以将其删除（我将日期时间用于说明目的）; 
 
CONVERT(DATETIME, REPLACE('20161021-12:55:16.000','-',' '), 102) 
 
 结果 
 
2016-10-21 12:55:16.000
 
 对于转换，您可以转换为日期时间，取消您的小时数，然后转换为您想要的日期格式; 
 
CONVERT(DATETIME, DATEADD(hh,-5,CONVERT(DATETIME,REPLACE('20161021-12:55:16.000','-',' '))), 102)
 
 结果; 
 
2016-10-21 07:55:16.000
 
 为了更好地了解这一点，请在凌晨5点之前设置它，然后您将获得前一天; 
 
CONVERT(DATETIME, DATEADD(hh,-5,CONVERT(DATETIME,REPLACE('20161021-04:55:16.000','-',' '))), 102)
 
 结果 
 
2016-10-20 23:55:16.000
 
 作为参考，在我的测试系统上，您不需要转换为102，这是默认值。 
 
DATEADD(hh,-5,CONVERT(DATETIME,REPLACE('20161021-04:55:16.000','-',' ')))
 
 为了获得动态的时差，可以做这样的事情; 
 
DATEADD(hh,DATEDIFF(hh,GETUTCDATE(),GETDATE()),CONVERT(DATETIME,REPLACE('20161021-04:55:16.000','-',' ')))

If you're confident with your format being consistent then you can just take that dash out (I've used datetime for illustration purposes);
 
CONVERT(DATETIME, REPLACE('20161021-12:55:16.000','-',' '), 102) 
 
Result
 
2016-10-21 12:55:16.000
 
For the conversion you can convert to datetime, take off your hours and then convert to the date format you want;
 
CONVERT(DATETIME, DATEADD(hh,-5,CONVERT(DATETIME,REPLACE('20161021-12:55:16.000','-',' '))), 102)
 
Result;
 
2016-10-21 07:55:16.000
 
To get a better idea of this, set it before 5am and you will get the previous day;
 
CONVERT(DATETIME, DATEADD(hh,-5,CONVERT(DATETIME,REPLACE('20161021-04:55:16.000','-',' '))), 102)
 
Result
 
2016-10-20 23:55:16.000
 
For reference, on my test systems you don't need to convert to 102, that's the default.
 
DATEADD(hh,-5,CONVERT(DATETIME,REPLACE('20161021-04:55:16.000','-',' ')))
 
To get the time difference dynamically do something like this;
 
DATEADD(hh,DATEDIFF(hh,GETUTCDATE(),GETDATE()),CONVERT(DATETIME,REPLACE('20161021-04:55:16.000','-',' ')))