U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » How to store a DATETIME in Sqlite?

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

Return to the default flat view

Create a new topic

Submit Reply

Re: How to store a DATETIME in Sqlite? [message #38344 is a reply to message #38141]

Tue, 11 December 2012 20:32

lectus is currently offline

lectus
Messages: 329
Registered: September 2006
Location: Brazil

Senior Member

Hi!

If I want to store a U++ Time in DD/MM/YYYY HH:MM format in Sqlite database what do I need to do?

I'm having trouble deciding if I should use:

TABLE_(MY_TABLE)
	DATE_ (tm)
END_TABLE

or

TABLE_(MY_TABLE)
	TIME_ (tm)
END_TABLE

or even

TABLE_(MY_TABLE)
	DATETIME_ (tm)
END_TABLE

in .sch files.

I'm using a SqlArray control.

[Updated on: Tue, 11 December 2012 20:33]

Report message to a moderator

Send a private message to this user

[Message index]

		How to store a DATETIME in Sqlite? By: lectus on Sun, 02 December 2012 16:22
		Re: How to store a DATETIME in Sqlite? By: dolik.rce on Sun, 02 December 2012 17:24
		Re: How to store a DATETIME in Sqlite? By: lectus on Tue, 11 December 2012 20:32
		Re: How to store a DATETIME in Sqlite? By: mirek on Sun, 23 December 2012 10:23

Previous Topic:	SqlLite3 crashes on Fetch()
Next Topic:	Use ctrls in another tab as detail problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Fri Apr 26 01:00:37 CEST 2024

Total time taken to generate the page: 3.01011 seconds