kb:kb_item_4
This is an old revision of the document!
Table of Contents
KB Item 4
Product
None
Product Version (if applicable)
None Defined
Issue
SQL Function to Create DateTime Value
Symptom
Cause
Resolution Notes
Create FUNCTION [dbo].[CreateDateTime] (@Date datetime, @Time varchar(4))
RETURNS DateTime AS
BEGIN
Declare @NewTime datetime
Declare @Hour int
Declare @Minute int
If len(@time) = 3
Begin
Set @Hour = cast(left(@time,1) as int)
End
Else
Begin
Set @Hour = cast(left(@time,2) as int)
End
Set @Minute = cast(right(@Time,2) as int)
Set @NewTime = dateadd(hh,@hour, @Date)
Set @NewTime = dateadd(n, @Minute, @NewTime)
Return @newtime
END
KB Type
Solution
Item Date
30 Apr 2007
kb/kb_item_4.1548341048.txt.gz · Last modified: 2019/01/24 09:44 by
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
