On Jan 29, 2013, at 1:28 PM, Steven Robinson wrote: > Hello, > > As you may know, SQLite is a bit special when it comes to store date- > like data. One can use Strings, integers and floats in order to store > dates. > > Right now sqlalchemy uses ISO-style strings by default which is great > if the database is only used by sqlalchemy. Unfortunately, I also want > to use hibernate on top of that. Unfortunately, the java sqlite driver > assumes those date fields to be stored as integers representing the > number of millisecond since the early 1-1-1970 (kind of a unix > timestamp). > > I am thus looking for a way to get sqlalchemy (latest version) to > store and read datetime data from sqlite using unix timestamps instead > of a string. > > > How would you suggest me for doing that?
see the EpochType example right here: http://docs.sqlalchemy.org/en/rel_0_8/core/types.html#augmenting-existing-types > > Thank you very much in advance! > > > S > > -- > 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?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
