appending two datetimes which were converted from strings

[paul_zaoldyeck]

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

[Dan Guzman]

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" <ni*****@yahoo.comwrote in message
news:11*********************@k70g2000cwa.googlegro ups.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

[paul_zaoldyeck]

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" <ni*****@yahoo.comwrote in message
news:11*********************@k70g2000cwa.googlegro ups.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

[Ed Murphy]

paul_zaoldyeck wrote:

how can i convert a char(4) into a time where the datatype of the
column is datatime?

Combine it with an appropriate date (today's date, a date from a
related record, whatever) in a similar fashion to the previous
answer. If you don't care about the date, then pick a fixed value
(e.g. January 1, 1970) and use that in all cases.

[Dan Guzman]

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" <ni*****@yahoo.comwrote in message
news:11*********************@b28g2000cwb.googlegro ups.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" <ni*****@yahoo.comwrote in message
news:11*********************@k70g2000cwa.googlegr oups.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