|
Posted by Dan Guzman on 11/23/06 15:13
The example below parses a string in hh:mm format into a datetime variable.
Note that a datetime always includes both date and time components so your
app will need to ignore the date part, if not needed. The date defaults to
'19000101'.
DECLARE
@MyTimeString char(4),
@MyDateTime datetime
SET @MyTimeString = '1213' --hh:mm
SET @MyDateTime = LEFT(@MyTimeString, 2) + ':' + LEFT(@MyTimeString, 2) +
':00'
SELECT @MyDateTime
--
Hope this helps.
Dan Guzman
SQL Server MVP
"paul_zaoldyeck" <niopaul@yahoo.com> wrote in message
news:1164254851.864579.14760@b28g2000cwb.googlegroups.com...
> thanks for the answer.it worked.
>
> i have another problem.
>
> how can i convert a char(4) into a time where the datatype of the
> column is datatime?
>
> i think this is my only problem now.thanks
> Dan Guzman wrote:
>> > the time is converted from string.
>>
>> One method is to build a string containing both date and time in format
>> is
>> 'yyyymmdd hh:mm:ss'. SQL Server can then parse the string into a
>> datetime
>> value. For example:
>>
>> DECLARE
>> @MyDate datetime,
>> @MyTime datetime,
>> @MyDateTime datetime
>>
>> SET @MyDate = '20061121'
>> SET @MyTime = '12:13:14'
>>
>> --concatenate date and time strings and assign to datetime data type
>> SET @MyDateTime =
>> CONVERT(char(9), @MyDate, 112) +
>> CONVERT(char(8), @MyTime, 114)
>>
>> --
>> Hope this helps.
>>
>> Dan Guzman
>> SQL Server MVP
>>
>> "paul_zaoldyeck" <niopaul@yahoo.com> wrote in message
>> news:1164084180.584403.64710@k70g2000cwa.googlegroups.com...
>> > can anyone teach me how to append to datetime data into one.
>> > the first is a date and the 2nd one is a time.
>> >
>> > the time is converted from string.
>> >
>> > thanks
>> >
>
Navigation:
[Reply to this message]
|