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

Re: Date emulation for Sqlite [message #5294 is a reply to message #5291]

Tue, 12 September 2006 20:07

unodgs
Messages: 1367
Registered: November 2005
Location: Poland

Ultimate Contributor

The only problem with sqlite is when you select "stringed dates" into value and you want that value to be date type.
Now I use ScanDate which seems to work well.

Value dt = ScanDate(String(SQL[DT])); //DT column that holds date

Date ScanDate(String &s)
{
if(s.IsEmpty())
return Null;
int year = atoi(s.Left(4));
int month = atoi(s.Mid(5, 2));
int day = atoi(s.Right(2));

return Date(year, month, day);
}

But I agree that is troublesome and your chage is wanted.

[Updated on: Tue, 12 September 2006 22:24]

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 Jul 08 14:15:29 CEST 2025

Total time taken to generate the page: 0.04934 seconds