Nick, You should have answered your own question in the text.
The MySql TIMESTAMP type is, as all other timestamps in the *nix world, a count of seconds since epoch time. The Java function you are using yields MILLI-seconds. Divide it by 1000 and you should be good to go. On Wed, Aug 21, 2013 at 6:03 PM, Nick Khamis <sym...@gmail.com> wrote: > Hello Everyone, > > We have the following mysql timetampe field > > startdate | timestamp | NO | | 0000-00-00 00:00:00 > > When trying to insert a long value in there: > > Calendar c = Calendar.getInstance(TimeZone.getTimeZone("UTC")); > c.getTimeInMillis(); > > We are presented with the following error: > > com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect > datetime value: '1377119243640' for column 'stopdate' at row 1 > > > Our environments is: > > JDBC Driver = 5.1.26 > Mysql = 5.5 > > > show variables like 'time_zone%'; > +---------------+--------+ > | Variable_name | Value | > +---------------+--------+ > | time_zone | +00:00 | > +---------------+--------+ > > SELECT @@global.sql_mode; > +-------------------+ > | @@global.sql_mode | > +-------------------+ > | | > +-------------------+ > > Not sure why I am getting this error. > > > Thanks in Advance, > > Nick. -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql