U++ forum: Welcome to the forum

Search on this site

Search in forums

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

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

Date emulation for Sqlite [message #5291]

Tue, 12 September 2006 17:37

mirek
Messages: 14263
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: Mon Jun 30 17:01:56 CEST 2025

Total time taken to generate the page: 0.03747 seconds