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. (timezone sensitive)
On Sun, Oct 19, 2008 at 1:27 PM, Rama <[EMAIL PROTECTED]> wrote:
> 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)
> @ GMT+05:30
>
> 5) when i retrieved the date from mysql (GMT +05:30)
> ---------------------------------Java (GMT)
> 2008-10-19 @ GMT+05:30
> ------------------------------------------- 2008-10-18 18:30 (GMT)
>
> converted to
>
>
> the above is the reason why it is printing the previous day date.
> On Sun, Oct 19, 2008 at 1:15 PM, SK <[EMAIL PROTECTED]> 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
>>>
>>
>>
>
