Hi, For an unknown reason I did not receive your original mail, but only this one, with your 'solution'. And I have no idea which problem could be solved with this 'solution'.
To explain the problem: timestamp is a character-value looking like a number --> dividing it is very uncommon timestamp includes year, month, day, hour, minute, second and MICROSECOND. 86400000 is the number of MILLISECONDs of a day. Even assuming that we do not use 86400000, but 86400000000, for the division of now '20070802103215123456' and this value my calculator tells me something about 232300950,...... (many digits in the fractional part) And you use this result as number of days, meaning some day in the year 636440. Sorry, but this cannot be what you really want Elke SAP Labs Berlin Sitz der Gesellschaft/Registered Office: Walldorf, Germany Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), Léo Apotheker, Werner Brandt, Claus Heinrich, Gerhard Oswald, Peter Zencke Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: Hasso Plattner Registergericht/Commercial Register Mannheim No HRB 350269 Diese E-Mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielfältigung oder Weitergabe der E-Mail ausdrücklich untersagt. Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen Dank. This e-mail may contain trade secrets or privileged, undisclosed, or otherwise confidential information. If you have received this e-mail in error, you are hereby notified that any review, copying, or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal. Thank you for your cooperation. > -----Original Message----- > From: Ralf Bast [mailto:[EMAIL PROTECTED] > Sent: Donnerstag, 2. August 2007 08:48 > To: maxdb@lists.mysql.com > Subject: [LIKELY JUNK]UNIX Timestamp > > Hi, > this problem has been solved. > I think i got a solution: > > ADDDATE('1970-01-01',timestamp / 86400000) > > Just a bit to fast posted. > > Regards > Ralf > > ______________________________________________________________ > ___________ > In 5 Schritten zur eigenen Homepage. Jetzt Domain sichern und > gestalten! > Nur 3,99 EUR/Monat! http://www.maildomain.web.de/?mc=021114 > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
