How can i insert the value of two column combine into table?

Question

I have a table defined as class - Id, Date, Time, Session, Remark Int is auto incremented Date,Time and Remark will be added automatically

Session should be the concatenate of (Date + Time)

Suppose Date and Time is varchar(50)

Insert into class (Date,Time,Session,Remark) Values ('a','b', Concat(Date + Time),'c')

Example:
Date - 12/12/2012
Time - 9:00 - 11:00am
Then --> Session - 12/12/2012 9:00-11:00am

@fa06 i have edited above! – WYMO Wai Yan Feb 04 '19 at 11:25 — WYMO Wai Yan, Feb 04 '19 at 11:25

score 0 · Answer 1 · edited Feb 04 '19 at 10:35

0

Why not you have used CONCAT if Session is VARCHAR data type

INSERT INTO t VALUES(CONCAT('2019-01-12', '12:00'))

edited Feb 04 '19 at 10:35

R. García

815
9
20

answered Feb 04 '19 at 10:32

Zaynul Abadin Tuhin

31,407
5
33
63

i use concat(date,time) for the session but getting error – WYMO Wai Yan Feb 04 '19 at 11:24
@WYMOWaiYan https://dbfiddle.uk/?rdbms=sqlserver_2017&fiddle=ab0df4a8a1f1076d67c796d2620c2a4b check this here it works – Zaynul Abadin Tuhin Feb 04 '19 at 11:25

PSK · Answer 2 · 2019-02-04T10:39:08.027

0

You can simply write like following query if you are using proper data types, Date for [Date] and Time for [Time].

INSERT INTO [YOUR_TABLE]([DATE], [TIME], [SESSION], REMARK)
VALUES (@DATE, @TIME, CAST(@DATEAS DATETIME) + CAST(@TIME AS DATETIME),@REMARK)

edited Feb 04 '19 at 10:39

answered Feb 04 '19 at 10:33

PSK

17,547
5
32
43

Do you mean like this? Insert into class (Date, time, Session, Remark) VALUES ('a', 'b', Cast(Date + Time), 'c') – WYMO Wai Yan Feb 04 '19 at 10:56
can you tell me sample value of date and time? – PSK Feb 04 '19 at 10:59
Date - 12/12/2012 Time - 9:00 - 11:00am Session - 12/12/2012 9:00-11:00am – WYMO Wai Yan Feb 04 '19 at 11:05
and what is the datatype? varchar or date and time – PSK Feb 04 '19 at 11:06
its just VARCHAR(50) – WYMO Wai Yan Feb 04 '19 at 11:07
in that case what you are doing is correct Insert into class (Date,Time,Session,Remark) Values ('a','b', Concat(Date + Time),'c') – PSK Feb 04 '19 at 11:10
I get invalid column name for the Concat(Date + Time) – WYMO Wai Yan Feb 04 '19 at 11:19

Suraj Kumar · Answer 3 · 2019-02-04T11:32:09.333

0

You can also try this

CREATE TABLE #date (dt datetime)

declare @date Varchar(20) ='2019-01-29' 
declare @time Varchar(20)='11:06:31.095' 

INSERT INTO #date 
    SELECT CONVERT(datetime,Cast(@date as Datetime))+ CONVERT(datetime,Cast(@time as Datetime))

select * from #date

You can replace @date with date column and @time with time column.

edited Feb 04 '19 at 11:32

answered Feb 04 '19 at 10:34

Suraj Kumar

5,547
8
20
42

date and time is VARCHAR data type not dateTime – WYMO Wai Yan Feb 04 '19 at 11:24
@WYMOWaiYan Updated answer according to varchar datatype. – Suraj Kumar Feb 04 '19 at 11:32

How can i insert the value of two column combine into table?

3 Answers3