From 423e51b081231278ee29dc157f0c19bfd874c275 Mon Sep 17 00:00:00 2001
From: Rob Holland <rob@inversepath.com>
Date: Sat, 17 May 2008 16:05:53 +0100
Subject: be more granular with time/data translation

---
 lib/sqlite3/translator.rb | 9 +++++----
 1 file changed, 5 insertions(+), 4 deletions(-)

(limited to 'lib/sqlite3')

diff --git a/lib/sqlite3/translator.rb b/lib/sqlite3/translator.rb
index d91671e..3590f6c 100644
--- a/lib/sqlite3/translator.rb
+++ b/lib/sqlite3/translator.rb
@@ -61,9 +61,11 @@ module SQLite3
     # Register the default translators for the current Translator instance.
     # This includes translators for most major SQL data types.
     def register_default_translators
-      [ "date",
-        "datetime",
-        "time" ].each { |type| add_translator( type ) { |t,v| Time.parse( v ) } }
+      [ "time",
+        "timestamp" ].each { |type| add_translator( type ) { |t, v| Time.parse( v ) } }
+
+      add_translator( "date" ) { |t,v| time = Time.parse(v); Date.new(time.year, time.month, time.day) }
+      add_translator( "datetime" ) { |t,v| DateTime.parse(v) }
 
       [ "decimal",
         "float",
@@ -91,7 +93,6 @@ module SQLite3
         end
       end
 
-      add_translator( "timestamp" ) { |type, value| Time.at( value.to_i ) }
       add_translator( "tinyint" ) do |type, value|
         if type =~ /\(\s*1\s*\)/
           value.to_i == 1
-- 
cgit