Merge two fields?

[chrisb]

Hi All,

Hopefully a simple one for you guys:

In my database I had two fields:

- web_date (date)
- web_time (time)

Now I want to merge these two fields into one:

- web_date_time (timestamp)

How can I do this in a SQL statement?

Thanks

Chris

[mattyblah]

what db?

[Ribeyed]

Hi,
if your inserting into new table then somethign like this:


INSERT INTO table1
(web_date_time)
SELECT web_date + web_time
FROM Table2