----- Original Message ----- > From: "Jan Steinman" <j...@ecoreality.org> > Subject: RE: converting numeric to date-time? > > I don't think the OP has a Unix timestamp.
OP explicitly says "epoch including milliseconds" - so it's going to be three digits too long :-) divide by 1000; split off decimal; from_unixtime(epoch) and add a millisecond display. -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql