Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • Advanced Productivity Pack (APP) • kb_item_366 • contact • Versago Environment Requirements • APP - Dashboards Screens • downloads
kb:kb_item_4

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

kb:kb_item_4 [2019/01/24 09:44]
external edit 		kb:kb_item_4 [2019/01/24 10:04] (current)
runger [Resolution Notes]
Line 12: Line 12:
  
 ==== Resolution Notes ==== ==== Resolution Notes ====
-Create FUNCTION [dbo].[CreateDateTime] (@Date datetime, @Time varchar(4)) +<code sql>Create FUNCTION [dbo].[CreateDateTime] (@Date datetime, @Time varchar(4))
 RETURNS DateTime AS   RETURNS DateTime AS  
- 
 BEGIN  BEGIN 
- 
 Declare @NewTime datetime Declare @NewTime datetime
- 
 Declare @Hour int Declare @Hour int
- 
 Declare @Minute int Declare @Minute int
 +--
 If len(@time) = 3 If len(@time) = 3
- 
       Begin       Begin
- 
       Set @Hour = cast(left(@time,1) as int)       Set @Hour = cast(left(@time,1) as int)
- 
       End       End
- 
 Else Else
- 
       Begin       Begin
- 
       Set @Hour = cast(left(@time,2) as int)       Set @Hour = cast(left(@time,2) as int)
- 
       End       End
- 
 Set @Minute = cast(right(@Time,2) as int) Set @Minute = cast(right(@Time,2) as int)
- 
 Set @NewTime = dateadd(hh,@hour, @Date) Set @NewTime = dateadd(hh,@hour, @Date)
- 
 Set @NewTime = dateadd(n, @Minute, @NewTime) Set @NewTime = dateadd(n, @Minute, @NewTime)
- 
 Return @newtime Return @newtime
- 
 END END
 +</code>
 ==== KB Type ==== ==== KB Type ====
 Solution Solution
kb/kb_item_4.1548341048.txt.gz · Last modified: 2019/01/24 09:44 by

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
CC Attribution-Noncommercial 4.0 International Valid HTML5 Valid CSS Driven by DokuWiki