Python Timestamp Examples

Example #1

File: ttypes.py Project: JakaKokosar/pysqlite3-binary

 def CheckDateTimeSubSecondsFloatingPoint(self):
     ts = sqlite.Timestamp(2004, 2, 14, 7, 15, 0, 510241)
     self.cur.execute("insert into test(ts) values (?)", (ts,))
     self.cur.execute("select ts from test")
     ts2 = self.cur.fetchone()[0]
     self.assertEqual(ts, ts2)

Example #2

File: dbapi.py Project: JakaKokosar/pysqlite3-binary

 def CheckTimestamp(self):
     ts = sqlite.Timestamp(2004, 10, 28, 12, 39, 35)

Example #3

File: ttypes.py Project: JakaKokosar/pysqlite3-binary

 def CheckSqliteTimestamp(self):
     ts = sqlite.Timestamp(2004, 2, 14, 7, 15, 0)
     self.cur.execute("insert into test(ts) values (?)", (ts,))
     self.cur.execute("select ts from test")
     ts2 = self.cur.fetchone()[0]
     self.assertEqual(ts, ts2)