Re: Java UTC Calendar and Mysql TimeStamp - Gets me every time!!!!!

2013-08-22 Thread hsv
2013/08/22 14:22 -0400, Nick Cameo SimpleDateFormat sdf = new SimpleDateFormat("-MM-dd'T'HH:mm:ss", new Locale("en", "US")); Well, you have your answer (FROM_UNIXTIME( /1000)), but that stupid ISO format with 'T' in the middle does not work, because to MySQL letters are n

Re: Java UTC Calendar and Mysql TimeStamp - Gets me every time!!!!!

2013-08-22 Thread Nick Cameo
Sorry, as was mentioned earlier: select FROM_UNIXTIME(1377196112065/1000); +---+ | FROM_UNIXTIME(1377196112065/1000) | +---+ | 2013-08-22 18:28:32 | +---+ Have a good day everyone :) Ni

Re: Java UTC Calendar and Mysql TimeStamp - Gets me every time!!!!!

2013-08-22 Thread Nick Cameo
On Wed, Aug 21, 2013 at 10:39 PM, wrote: > 2013/08/21 18:03 -0400, Nick Khamis > We have the following mysql timetampe field > > startdate | timestamp | NO | | -00-00 00:00:00 > > When trying to insert a long value in there: > > Calendar c = Calendar.getInstance(TimeZone.getTi

Re: MySQL version 3.23 to 5.x features

2013-08-22 Thread Nagaraj S
wow it really helped me a lot. I really thank Shawn,Dale Jesper for there inputs On Wed, Aug 21, 2013 at 7:13 PM, shawn green wrote: > Hello Naga, > > > On 8/21/2013 6:45 AM, Nagaraj S wrote: > >> Hello, >> >> Can anyone share the features/comparison from MySQL version 3.23 to 5.x in >> single d