combine date and time of two fields then insert into third field of table

Question

I have tbl1 which has field date and time.Suppose there's another table tbl2 with field date_time.Now,I want to take data from date & time field of tbl1,combine them and insert to date_time field of tbl2,in Y-m-d H:i:s format or which ever format possible.Please some one help,inserting from one table to another isn't a problem but combining value of two field then inserting to another table is making me headache?

What is the relation between these tables?

dhi_m
– dhi_m

2015-08-12 06:45:07 +00:00
Commented Aug 12, 2015 at 6:45 — dhi_m
– dhi_m, Commented Aug 12, 2015 at 6:45

DNReNTi · Accepted Answer · 2015-08-12 06:46:36Z

1

You should concatenate the date and time field from tbl1.

Something like this:

INSERT INTO tbl2 (datetime_field) 
VALUES (SELECT CONCAT(date_filed, ' ', time_field) 
        FROM tbl1 WHERE pk_field = your_condition);

Notice: The sub-select must return only one result!

answered Aug 12, 2015 at 6:46

DNReNTi

5214 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Harish Lalwani · Accepted Answer · 2015-08-12 06:46:44Z

1

  INSERT INTO tbl2 (date_time)  
  SELECT CONCAT(`date`, ' ', `time`)
  FROM tbl1
  WHERE your_condition

answered Aug 12, 2015 at 6:46

Harish Lalwani

7845 silver badges20 bronze badges

Collectives™ on Stack Overflow

combine date and time of two fields then insert into third field of table

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related