t; -
> > Default timezone : GMT Default
> > Timezone : GMT+5:30
> >
> > program trying to store
> >
> > date : 2008-10-20 12:23:09->stored as
> > : 2008-10-20 12:23:09
> >
> > program t
is the problem, i did not get what i
stored time is less by 5:30 hrs)
regards
rama
On Tue, Oct 21, 2008 at 5:46 AM, Moon's Father <[EMAIL PROTECTED]>wrote:
> Timestamp is the best bridge between java and mysql,I think.
>
>
> On Sun, Oct 19, 2008 at 4:48 PM, Rama <[EMAIL PRO
e
use to fill mysql date" is not important in this context.
On Sun, Oct 19, 2008 at 1:33 PM, Roland Kaber <[EMAIL PROTECTED]> wrote:
> SK wrote:
>
>> 2008/10/19 Rama <[EMAIL PROTECTED]>
>>
>>
>>
>>> hi,
>>>
>>> iam using
. (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 mys
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.
please
guide me on What can go wrong in above scenario?
--rama
across different
areas of MySQL.*
Hope such a utility will be helpful to all in discovering community
recommended links across different areas of MySQL.
regards
rAma
hi,
This is kathir from Uniware Systems, We are developing project on ASP with Backend
as MySQL, We having a problem using "IN" and "NOT IN" operators in sub query
here i am listing my query as follows:
"select c.pickupdate,c.contno, r.relrefno, r.custname, r.contsize, r.conttype,
r.qtybooke