You are here: Re: appending two datetimes which were converted from strings « MsSQL Server « IT news, forums, messages
Re: appending two datetimes which were converted from strings

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]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация