Re: [sqlite] Date/Time Pains

2008-09-22 Thread Scott Baker
jason weaver wrote: > I've searched and searched but haven't found anything that really answers > this question. If I've missed something, please point me in the right > direction. > > I want to put the "right" type of timestamp in my dbase. According to my > research, the "right" type is like

Re: [sqlite] Date/Time Pains

2008-09-22 Thread Tomas Lee
On 2008 September 22 (Mon) 06:25:34am PDT, jason weaver <[EMAIL PROTECTED]> wrote: > "jason weaver" <[EMAIL PROTECTED]> wrote: > news:[EMAIL PROTECTED] >>> However, due to database locking issues, I need to do a bunch of >>> inserts in one transaction or batch. Thus, I store them in a simple >>>

Re: [sqlite] Date/Time Pains

2008-09-22 Thread John Stanton
jason weaver wrote: > "jason weaver" <[EMAIL PROTECTED]> wrote: > news:[EMAIL PROTECTED] >>> However, due to database locking issues, I need to do a bunch of >>> inserts in one transaction or batch. Thus, I store them in a simple >>> queue. Therefore, the julianday('now') won't work because all

Re: [sqlite] Date/Time Pains

2008-09-22 Thread Jay A. Kreibich
On Mon, Sep 22, 2008 at 08:25:34AM -0500, jason weaver scratched on the wall: > What is the julianday("now") equivalent in python? I can't find a simple, > straight-forward answer to this question. Just ask SQLite for the time: SELECT julianday('now'); (It is single quotes, BTW).

Re: [sqlite] Date/Time Pains

2008-09-22 Thread Jeffrey Becker
Instead of doing julianday('now') why not put a text-based timestamp into whatever object you're queueing up and pass that into the julianday() function to convert it to a real. On Mon, Sep 22, 2008 at 9:51 AM, P Kishor <[EMAIL PROTECTED]> wrote: > On 9/22/08, jason weaver <[EMAIL PROTECTED]>

Re: [sqlite] Date/Time Pains

2008-09-22 Thread P Kishor
On 9/22/08, jason weaver <[EMAIL PROTECTED]> wrote: > "jason weaver" <[EMAIL PROTECTED]> wrote: > news:[EMAIL PROTECTED] > >> However, due to database locking issues, I need to do a bunch of > >> inserts in one transaction or batch. Thus, I store them in a simple > >> queue. Therefore, the

Re: [sqlite] Date/Time Pains

2008-09-22 Thread jason weaver
"jason weaver" <[EMAIL PROTECTED]> wrote: news:[EMAIL PROTECTED] >> However, due to database locking issues, I need to do a bunch of >> inserts in one transaction or batch. Thus, I store them in a simple >> queue. Therefore, the julianday('now') won't work because all of my >> batch inserts will

Re: [sqlite] Date/Time Pains

2008-09-21 Thread Igor Tandetnik
"jason weaver" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > However, due to database locking issues, I need to do a bunch of > inserts in one transaction or batch. Thus, I store them in a simple > queue. Therefore, the julianday('now') won't work because all of my > batch

[sqlite] Date/Time Pains

2008-09-21 Thread jason weaver
I've searched and searched but haven't found anything that really answers this question. If I've missed something, please point me in the right direction. I want to put the "right" type of timestamp in my dbase. According to my research, the "right" type is like this: - create table