Move data from one table to another - one column is changing 1

[Sypher2]

I need to move data from one table to another. The two tables have identical structures. Obviously I can use:

INSERT INTO Table 2 SELECT * FROM Table 1

However one column needs to change. Is there a way to plug in this new value during the INSERT INTO statement or am I stuck having to update every row that was inserted?

Example:
Table 1 has the following column values:
1. 4/1/2006 8:01:56 AM
2. 15000
3. 20000

Table 2 needs to have:
1. 4/1/2006 8:00:00 AM
2. 15000
3. 20000

Thanks

 

[bborissov]

INSERT INTO Table2;
SELECT DateTime(2006,1,4,8,0,0), field2, fleid3 FROM Table1

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[bborissov]

OOOOOOOOOOOOOOOOOOOOOOOO
Veery sorry for this post. I think I read VFP forums :-(
Try this:

INSERT INTO TABLE2
SELECT CAST('2006-04-01 08:00:00' as datetime), Field2, Field3 FROM Table1

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[SQLDenis]

INSERT INTO Table2
SELECT convert(DateTime,'20060401'), field2, field3, <rest of fields here>
FROM Table1

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/