>>>> 2014/09/04 08:40 -0700, Jan Steinman >>>> > From: "Ed Mierzwa (emierzwa)" <emier...@micron.com> > > > FROM_UNIXTIME(1409304102.153) /*your epoch column here*/
I don't think the OP has a Unix timestamp. The number looks suspeciously like concatenation of date digits, "140930" at the beginning looks like September 30, 2014. If that's the case, you need to write something that will tear it apart. <<<<<<<< MySQL s interpretation of timestamps is already such that not much such code is needed: see "Overview of Date and Time Types". If this, "140930", really were September 30, 2014 it would be enough to write SELECT DATE(140930) This also works: SELECT CAST(140930210215 AS DATETIME) One does not need to write apart-tearing code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
