2008/10/19 Rama [EMAIL PROTECTED]
hi,
iam using java,hibernate,mysql
i am storing *19-10-2008 (*of type java.sql.Date) (TIMEZONE GMT) to
mysql
DATE field.
when i retrieve the same date from mysql to java it is being displayed as
*18-10-2008 18:30:00 GMT *
i could not able to
Le mardi 24 janvier 2006 à 19:08 +0100, fabsk a écrit :
Thank you a lot for your answer. The bug is there: if I drop the index
'tp_idx_part_solution', the result of the count is OK.
I recreated this index and the cound drop to 2 again.
It doesn't happen on version 4.1.12-Max on my machine
Le mardi 24 janvier 2006 à 19:23 +0100, Fabien SK a écrit :
Le mardi 24 janvier 2006 à 19:08 +0100, fabsk a écrit :
Thank you a lot for your answer. The bug is there: if I drop the index
'tp_idx_part_solution', the result of the count is OK.
I recreated this index and the cound drop to 2
Thank you for you answer, but I read many times and I did not found
something to answer my question (well, I did not know about the NULL).
In my case:
- there is one table
- htere is no distinct
- there is a WHERE clause, so there is no optimisation
- there is no other field and no group by
If I
, WIN95 OSR2, 4GB partition.
Please help
Sk Islam
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL