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
please
guide me on What can go wrong in above scenario?
--rama
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.
. (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
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
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
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
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
