Ruby/DBI + MySQLで日付型のタイムゾーンが変
これはバグちゃうのか。設定の問題なのか???
#!/usr/bin/ruby require 'dbi' dbh = DBI.connect("DBI:Mysql:dbname:hostname", "username", "password") sth = dbh.execute('SELECT NOW()') sth.fetch do |row| p row[0] p row[0].to_time p Time.now p (row[0].to_time - Time.now) end
の結果がこれだよ!!
#<DBI::Timestamp:0xb7b724f8 @year=2009, @second=6, @fraction=nil, @day=16, @minute=10, @month=7, @hour=7, @original_time=Thu Jul 16 07:10:06 UTC 2009> Thu Jul 16 07:10:06 UTC 2009 Thu Jul 16 07:10:06 +0900 2009 32399.453733
え〜と、9時間ずれてますね!!なんでやねん!!