RE: UNIX Timestamp

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=20

  Elke
SAP Labs Berlin
=20
Sitz der Gesellschaft/Registered Office: Walldorf, Germany

Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), L=E9o =
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=E4ftsgeheimnisse oder sonstige =
vertrauliche Informationen enthalten. Sollten Sie diese E-Mail =
irrt=FCmlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, =
eine Vervielf=E4ltigung oder Weitergabe der E-Mail ausdr=FCcklich =
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.=20

=20

> -----Original Message-----
> From: Ralf Bast [mailto:[email protected]]=20
> Sent: Donnerstag, 2. August 2007 08:48
> To: [email protected]
> Subject: [LIKELY JUNK]UNIX Timestamp
>=20
> Hi,
> this problem has been solved.
> I think i got a solution:
>=20
> ADDDATE('1970-01-01',timestamp / 86400000)
>=20
> Just a bit to fast posted.
>=20
> Regards
> Ralf
>=20
> ______________________________________________________________
> ___________
> In 5 Schritten zur eigenen Homepage. Jetzt Domain sichern und=20
> gestalten!=20
> Nur 3,99 EUR/Monat! http://www.maildomain.web.de/?mc=3D021114
>=20
>=20
> --=20
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:   =20
> http://lists.mysql.com/[email protected]
>=20
>=20

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[email protected]