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
i figured out the root cause of the problem.
1) Java TIME ZONE is GMT --- storing DATE (2008-10-19
which is in GMT )
2) storing the above date in GMT to mysql
3) MYSQL TIME ZONE IS GMT+05:30
4) as mysql time zone is GMT+05:30 it is viewing the date as (2008-10-19) @
The above argument applies to only MYSQL DATE field (timezone
sensitive)
where as in the case DATETIME Field it does not do any conversion gets
what we store (timezone insensitive)
in the case of TIMESTAMP Field it gets converted between UTC
and local timezone.
SK wrote:
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
DATE TIME ZONE SENSITIVE
DATETIME NOT SENSITIVE TO TIME ZONE
TIMESTAMP TIMEZONE SENSITIVE
iam getting the above problem as date is timezone sensitive.i resolved it
by changing the field type from date to string.
YOu can use any method to fill the DATE field of mysql .which method we
use
hi ronaldo,
iadmit i was mysql (the command) fixated :)
thx a lot,
wh
Rolando Edwards schrieb:
Try mysqldump !!!
On this web page, http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
It says the following:
--fields-terminated-by=..., --fields-enclosed-by=...,
hi ronaldo i tried and failed.
it seems that mysql has no option to specify a select statement.
did i mis something ?
re,
wh
walter harms schrieb:
hi ronaldo,
iadmit i was mysql (the command) fixated :)
thx a lot,
wh
Rolando Edwards schrieb:
Try mysqldump !!!
On this web page,
Hi,
For mysql stress test suite (mysql-stress-test.pl) to execute, it requires
--stress-tests-file to be provided which contains the list of tests to be
executed. As per the documentation the default name of the file is
stress-test.txt and it will be located under ./mysql-test directory.
But I
