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 able to figure out what is going wrong . can any one please
guide me on What can go wrong in above scenario?
there are a lot of mothods to express data in java,but in mysql only have
one type.
may be types not match.
i think you should storing "19-10-2008" to mysql char(10) field.
--rama
Hi
What about using the STR_TO_DATE function to transform the java Date as
a MySQL Date: STR_TO_DATE('19/10/2008', '%m/%d/%Y')? To transform this
back into the original format, you may use the DATE_FORMAT function:
DATE_FORMAT('2008-10-19', '%d/%m/%Y).
Best regards
Roland
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
