Re: MySQL Date problem

2008-10-20 Thread Rama
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

Re: MySQL Date problem

2008-10-20 Thread Rama
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

Re: MySQL Date problem

2008-10-19 Thread Rama
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

Re: MySQL Date problem

2008-10-19 Thread Rama
. (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

Re: MySQL Date problem

2008-10-19 Thread 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.

MySQL Date problem

2008-10-18 Thread Rama
please guide me on What can go wrong in above scenario? --rama

MySQL Fuse

2008-08-27 Thread 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

Technical Clarification

2001-03-18 Thread Rama kathiresan kathiresan
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