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 PROTECTED] wrote:
DATE TIME ZONE
:23:09---
2008-10-20
12:23:09
(here 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
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
. (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
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 java,hibernate,mysql
i am storing *19-10-2008 (*of type java.sql.Date) (TIMEZONE GMT) to
mysql
DATE
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,