Hi all,
I have been writing to my database using func.now(6) for datetime(6) valued
columns and it has worked perfectly. However, I've recently run into an
issue with querying for these values. It would appear that every time I
query for the values in datetime(6) columns it returns None.
Examples of datetime(6) values:
- '2013-07-10 17:22:49.113604'
- '2013-07-10 17:55:08.920235'
Attempts at retrieving datetime(6) values from the database:
*python:*
print self.engine.execute("select now()").scalar()
print self.engine.execute("select now(6)").scalar()
*output:*
2013-07-11 16:33:04
None
and same thing happens when retrieving an entire row from a table. I didn't
think it was necessary to go into that sort of detail as I'm hoping this is
an easy fix, but if need be I can show parts of my schema and datamodel
along with queries and results for those records.
Any insight would be great.
Thanks,
Matt
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.
