U++ framework: U++ Developers corner » Date emulation for Sqlite

Home » Developing U++ » U++ Developers corner » Date emulation for Sqlite

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Date emulation for Sqlite [message #5291]

Tue, 12 September 2006 17:37

mirek
Messages: 14290
Registered: November 2005

Ultimate Member

Sqlite does not support DATE type, which is a bit trouble with U++, as we cannot use natural Date <- column conversions.

I have this idea of Date emulation in Sqlite:

Store Date d as

(d - Date(1970, 1, 1)) * 1.0e300.

This way we would know that any double stored in database bigger than 1.0e300 is Date. Comparisons would work as well, the only downsize is that "number of days between" would be a bit high and that you would not be able to store doubles bigger than 1.0e300...

Should I do that? Any better solutions?

Mirek

Report message to a moderator

[Message index]

		Date emulation for Sqlite By: mirek on Tue, 12 September 2006 17:37
		Re: Date emulation for Sqlite By: Ulti on Tue, 12 September 2006 18:20
		Re: Date emulation for Sqlite By: zsolt on Tue, 12 September 2006 18:28
		Re: Date emulation for Sqlite By: mirek on Tue, 12 September 2006 20:33
		Re: Date emulation for Sqlite By: zsolt on Tue, 12 September 2006 20:57
		Re: Date emulation for Sqlite By: mirek on Tue, 12 September 2006 21:01
		Re: Date emulation for Sqlite By: zsolt on Thu, 14 September 2006 11:02
		Re: Date emulation for Sqlite By: zsolt on Thu, 14 September 2006 11:26
		Re: Date emulation for Sqlite By: mirek on Fri, 15 September 2006 14:18
		Re: Date emulation for Sqlite By: fabio on Sun, 26 November 2006 18:07
		Re: Date emulation for Sqlite By: zsolt on Sun, 26 November 2006 18:24
		Re: Date emulation for Sqlite By: unodgs on Tue, 12 September 2006 20:07

Previous Topic:	A new way how to create "plugin"
Next Topic:	uvs2 as "public application"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Apr 28 17:28:08 GMT+2 2026

Total time taken to generate the page: 0.00906 seconds