Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » How to store a DATETIME in Sqlite?
How to store a DATETIME in Sqlite? [message #38139] Sun, 02 December 2012 16:22 Go to next message
lectus is currently offline  lectus
Messages: 329
Registered: September 2006
Location: Brazil
Senior Member
My app seemed to work on Linux, but on Windows it only stores the Date. The time information is missing.
Re: How to store a DATETIME in Sqlite? [message #38141 is a reply to message #38139] Sun, 02 December 2012 17:24 Go to previous messageGo to next message
dolik.rce is currently offline  dolik.rce
Messages: 1778
Registered: August 2008
Location: Czech Republic
Senior Contributor

lectus wrote on Sun, 02 December 2012 16:22

My app seemed to work on Linux, but on Windows it only stores the Date. The time information is missing.

Hi,

Can you show us the relevant part of your table schema and your code handling the storing and reading of this value?

Honza

[Updated on: Sun, 02 December 2012 17:24]

Report message to a moderator

Re: How to store a DATETIME in Sqlite? [message #38344 is a reply to message #38141] Tue, 11 December 2012 20:32 Go to previous messageGo to next message
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

Re: How to store a DATETIME in Sqlite? [message #38554 is a reply to message #38344] Sun, 23 December 2012 10:23 Go to previous message
mirek is currently offline  mirek
Messages: 12735
Registered: November 2005
Ultimate Member
TIME
Previous Topic: SqlLite3 crashes on Fetch()
Next Topic: Use ctrls in another tab as detail problem
Goto Forum:
  


Current Time: Wed Sep 30 07:10:23 CEST 2020

Total time taken to generate the page: 0.01170 seconds