|
Execute the following
script in Management Studio Query Editor to convert from string format to datetime:
DECLARE
@DateTimeValue varchar(30),
@DateValue char(8),
@TimeValue char(6)
SELECT
@DateValue = '20081023',
@TimeValue = '211920'
SELECT @DateTimeValue =
convert(varchar, convert(datetime, @DateValue), 110)
+ ' ' + substring(@TimeValue, 1, 2)
+ ':' + substring(@TimeValue, 3, 2)
+ ':' + substring(@TimeValue, 5, 2)
SELECT
DateInput = @DateValue,
TimeInput = @TimeValue,
DateTimeOutput = @DateTimeValue,
DateTimeFormat = convert(datetime, @DateTimeValue)
|