Hi Elke,
thank you very much for your work.
My original problem was that I wanted to convert a Unix timestamp to a
database date. Just in order to do calculations within SQL (DATEDIFF, ...)
A unix timstamp it the milliseconds since 1970-01-01 .
In normal case I store timestamps in a fixed(13) so its good for
arithmetical calculations.
If I now divide these Unix timestamp by the amount of milliseconds of
one day (86400000)the result will be the amount of days since
1970-01-01. And in the second step I add them to the date it self. As
result I got a date within the database. Now I'm ready for any further
calculations.
This was long time a problem for me, but tomorrow morning i got this idea :D
I hope things make more sense to you now.
Regards / Gruß
Ralf Bast
Zietlow, Elke schrieb:
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]
