Daily Archives: August 13, 2008

You are here:

Troel has written a great summary of the SQL standard for the timestamp data type along with its implementation in the big 5 databases (MySQL, PostgreSQL, Microsoft SQL Server, Oracle, and DB2). MySQL It turns out that MySQL does not support sub-second time or date formats. There is a MICROSECOND function in MySQL allowed to…

ActiveRecord SQL in script/console

InsightsBy Justin August 13, 2008 3 Comments

Rails’ ActiveRecord displays the exact SQL queries it performs into the development log. It is inconvenient to watch this log while you’re working in the `script/console` environment, however, and most advice for redirecting that log to STDOUT seemed not to work. Thanks to [Jamis Buck](http://weblog.jamisbuck.org/2007/1/31/more-on-watching-activerecord “More on watching ActiveRecord”), though, the solution has come to light:

Daily Archives: August 13, 2008

Timestamp support for Rails and MySQL/PostgreSQL/Oracle

ActiveRecord SQL in script/console