Is there a way to add a date and time together to get the datetime value in SQL?

Question

I have a date field, and a separate time field, that I want to concatenate or add together in SQL. For example, if my date field has 01-01-2010 and my time field has 12:00:00, I want to combine them or convert them into a datetime value of 01-01-01 12:00:00. Is this possible?

Answer 1

0

Yes. Try

declare @date datetime,            
    @timestr    varchar(10)            
            
select  @date = '2010-04-01',            
    @timestr    = '12:34:56'            
            
select  @date + ' ' + ' ' + @timestr

answered Apr 29 '10 at 04:48 AM

Squirrel 1
1.6k ● 1 ● 3

(comments are locked)

Is there a way to add a date and time together to get the datetime value in SQL?

Follow this question

Related Questions