Hi Folks,
we finally migrated from SAP DB 7.4 to MaxDB 7.6 and its performance is just
amazing.
We stillt got a problem with our Timestamps.
We have a Table called event where the colums DAY, MONTH and YEAR are saved.
The Days / Months are being saved witout leading zeros.
If we now perform a comparisonn between TIMESTAMP (YEAR&'-'&MONTH&'-'&YEAR&'
23:59:00.00000') > TIMESTAMP(NOW()) And Month our YEAR don't have a leading
zero if they are smaller 10 we get an SQL-Error. In SAP DB this worked out
for us without any problems.
Any hints?
Thanks alot!
Jan
_________________________________________________________________
Sie suchen E-Mails, Dokumente oder Fotos? Die neue MSN Suche Toolbar mit
Windows-Desktopsuche liefert in sekundenschnelle Ergebnisse. Jetzt neu!
http://desktop.msn.de/ Jetzt gratis downloaden!
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
