Posted by paul_zaoldyeck on 11/23/06 04:07

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
> >

• Next in forum: CONVERSION FROM CHAR(4) TO DATETIME
• Prev in forum: Pls Help With JOIN query...
• Thread view: Re: appending two datetimes which were converted from strings

[Reply to this message]