Re: [Rails] different date format in sqlite and mysql

2011-04-16 Thread Sebastian
On Sat, Apr 16, 2011 at 9:52 AM, Colin Law wrote: > On 16 April 2011 00:55, Sebastian wrote: >> On Fri, Apr 15, 2011 at 5:34 PM, Colin Law wrote: >>> On 15 April 2011 16:19, Colin Law wrote: >>> ... >>> Answering my own question, yes this appears to be a Ruby 1.9 >>> enhancement.  If you are us

Re: [Rails] different date format in sqlite and mysql

2011-04-16 Thread Colin Law
On 16 April 2011 00:55, Sebastian wrote: > On Fri, Apr 15, 2011 at 5:34 PM, Colin Law wrote: >> On 15 April 2011 16:19, Colin Law wrote: >> ... >> Answering my own question, yes this appears to be a Ruby 1.9 >> enhancement.  If you are using 1.9 then what happens if in the console >> you do >> r

Re: [Rails] different date format in sqlite and mysql

2011-04-15 Thread Sebastian
On Fri, Apr 15, 2011 at 5:34 PM, Colin Law wrote: > On 15 April 2011 16:19, Colin Law wrote: >> On 15 April 2011 15:49, Sebastian wrote: >>> On Fri, Apr 15, 2011 at 1:26 PM, Colin Law wrote: On 15 April 2011 00:07, Seb wrote: > created_at is stored differently in mysql then in sqlite.

Re: [Rails] different date format in sqlite and mysql

2011-04-15 Thread Colin Law
On 15 April 2011 16:19, Colin Law wrote: > On 15 April 2011 15:49, Sebastian wrote: >> On Fri, Apr 15, 2011 at 1:26 PM, Colin Law wrote: >>> On 15 April 2011 00:07, Seb wrote: created_at is stored differently in mysql then in sqlite. sqlite stores the dates like: 2011-04-14 22:52:52.7

Re: [Rails] different date format in sqlite and mysql

2011-04-15 Thread Colin Law
On 15 April 2011 15:49, Sebastian wrote: > On Fri, Apr 15, 2011 at 1:26 PM, Colin Law wrote: >> On 15 April 2011 00:07, Seb wrote: >>> created_at is stored differently in mysql then in sqlite. >>> sqlite stores the dates like: 2011-04-14 22:52:52.758612 >>> and mysql stores the date like: 2011-0

Re: [Rails] different date format in sqlite and mysql

2011-04-15 Thread Sebastian
On Fri, Apr 15, 2011 at 1:26 PM, Colin Law wrote: > On 15 April 2011 00:07, Seb wrote: >> created_at is stored differently in mysql then in sqlite. >> sqlite stores the dates like: 2011-04-14 22:52:52.758612 >> and mysql stores the date like: 2011-04-14 22:52:52 (possible rounded) >> When I outpu

Re: [Rails] different date format in sqlite and mysql

2011-04-15 Thread Colin Law
On 15 April 2011 00:07, Seb wrote: > created_at is stored differently in mysql then in sqlite. > sqlite stores the dates like: 2011-04-14 22:52:52.758612 > and mysql stores the date like: 2011-04-14 22:52:52 (possible rounded) > When I output the date with json formatting, it's returned as > 2011-

[Rails] different date format in sqlite and mysql

2011-04-14 Thread Seb
created_at is stored differently in mysql then in sqlite. sqlite stores the dates like: 2011-04-14 22:52:52.758612 and mysql stores the date like: 2011-04-14 22:52:52 (possible rounded) When I output the date with json formatting, it's returned as 2011-04-14T22:52:52Z regardless of the underlayi