Sorry, forgot to mention this is for mysql.
http://dev.mysql.com/doc/refman/5.6/en/fractional-seconds.html
On Thursday, July 11, 2013 4:38:03 PM UTC-4, Matt wrote:
>
> 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 sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.
