Insert Select problem 1

[randy4126]

I am trying to insert data into a table from another table. The problem comes in with the unix timestamp column. It always converts the the date to 0000-00-00 but if you run the select query by itself it works just fine(Gives the correct date). Could someone see what I am doing wrong. Here is my SQL statement:

Insert Into HistoryPeaksSGBW (SGID_HPSGBW, Bandwidth_HPSGBW, SDStreams_HPSGBW, HDStreams_HPSGBW, EffectiveStreams_HPSBW, TimeStamp_HPSGBW)
Select SGID_CSGBW, Bandwidth_CSGBW, SDStreams_CSGBW, HDStreams_CSGBW, EffectiveStreams_CSGBW, FROM_UNIXTIME(TimeStamp_CSGBW,'%Y-%d-%m')
from CurrentSGBW

Thanks for you help.

Randy

 

[r937]

that's because (some of) your dates are invalid

mysql insists on year-month-day sequence when specifying a date (although the date is stored internally completely differently)

use '%Y-%m-%d' instead of '%Y-%d-%m'



rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)

 

[randy4126]

That was it. I didn't notice I had the order wrong. I remember reading that in the docs now. Thanks a LOT!

Randy