Index: test/date.test
==================================================================
--- test/date.test
+++ test/date.test
@@ -9,11 +9,11 @@
 #
 #***********************************************************************
 # This file implements regression tests for SQLite library.  The
 # focus of this file is testing date and time functions.
 #
-# $Id: date.test,v 1.27 2008/05/20 14:01:59 shane Exp $
+# $Id: date.test,v 1.28 2008/06/12 05:16:15 shane Exp $
 
 set testdir [file dirname $argv0]
 source $testdir/tester.tcl
 
 # Skip this whole file if date and time functions are omitted
@@ -448,7 +448,21 @@
   {2007-01-01 12:59:59.600}
 datetest 13.6 {strftime('%Y-%m-%d %H:%M:%S', '2007-01-01 23:59:59.6')} \
   {2007-01-01 23:59:59}
 datetest 13.7 {strftime('%Y-%m-%d %H:%M:%f', '2007-01-01 23:59:59.6')} \
   {2007-01-01 23:59:59.600}
+
+# Test for issues reported by BareFeet <list.sql@tandb.com.au> on mailing list
+# SELECT datetime(julianday('2008-06-12','utc'), 'localtime') should give 2008-06-12 00:00:00
+do_test date-13.8 {
+  execsql {
+    SELECT datetime(julianday('2008-06-12','utc'), 'localtime')
+  }
+} {{2008-06-12 00:00:00}}
+# SELECT date(julianday('2008-06-12', 'utc'), 'localtime') should give 2008-06-12
+do_test date-13.9 {
+  execsql {
+    SELECT date(julianday('2008-06-12','utc'), 'localtime')
+  }
+} {2008-06-12}
 
 finish_test