Re[3]: [sqlite] Sample dll using

2006-12-23 Thread Slava Tutushkin 

AY> Can at whom is small sample on C/ะก ++?
It seems, there are quite good examples in the sqlite's documentation. Do you 
have any problems with it?

-- 
 Slava Tutushkin, http://aloner.ru
 mailto:[EMAIL PROTECTED]
 ICQ: 55463183


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re[2]: [sqlite] Bug in the precision of strftime function

2006-09-24 Thread Slava Tutushkin 

MJ> -4713-11-24 GC, which is -4712-01-01 JC" so datetime(0) does correctly
MJ> convert Julian Day 0 to a (proleptic) Gregorian date but not to a Julian
MJ> Date as (I think) I thought. That'll teach me to post follow-ups when

I see no problem here while, because it does not matters, what day julianday() 
references to, all we need - stable pivot point. I'm using REAL julianday() 
value for internal storage in sqlite only, after reading from DB I'm converting 
to boost::ptime.
But strftime was not returning precise values sometimes.

My post was about floating point problems with the milliseconds in the 
strftime. I was investigated it a little bit longer, and found out that even 
the query 
"select strftime('%Y-%m-%d %H:%M:%f', '2006-09-24T10:50:26.046');"
is returning 2006-09-24 10:50:26.045.

Anyway, somebody (thank you!) posted a patch in the ticket, solving this 
problem. I was not tested it for now, but seems it looks ok.
URL for ticket is:
http://www.sqlite.org/cvstrac/tktview?tn=1991

-- 
 Slava Tutushkin, http://aloner.ru
 mailto:[EMAIL PROTECTED]
 ICQ: 55463183


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Bug in the precision of strftime function

2006-09-24 Thread Slava Tutushkin 

I think, I found a bug in the strftime function.

When I executed the next query:
select strftime('%Y-%m-%d %H:%M:%f', julianday('2006-09-24T10:50:26.047'));
it returned 2006-09-24 10:50:26.046

At the same time, I can clearly see, that julianday for that time for .046 and 
.047 points is returning different numbers.
It seems, there is a bug in the strftime function.

-- 
 Slava Tutushkin, http://aloner.ru
 mailto:[EMAIL PROTECTED]
 ICQ: 55463183


-
To unsubscribe, send email to [EMAIL PROTECTED]
-