Status & Roadmap
Authors & License
Funding Ultimate++
Search on this site
Search in forums

SourceForge.net Logo
Home » U++ Library support » U++ SQL » Weird Date bevaviour in Sqlite
Weird Date bevaviour in Sqlite [message #38117] Sat, 01 December 2012 23:44 Go to next message
lectus is currently offline  lectus
Messages: 329
Registered: September 2006
Location: Brazil
Senior Member
I'm using a SqlArray together with Sqlite.
I try to insert a Date in 01/12/2012 format. After I reopen the application it comes as 2012-12-01 format.

How can I make it appear as 01/12/2012 format?
Re: Weird Date bevaviour in Sqlite [message #38122 is a reply to message #38117] Sun, 02 December 2012 07:55 Go to previous messageGo to next message
nlneilson is currently offline  nlneilson
Messages: 644
Registered: January 2010
Location: U.S. California. Mojave &...
lectus wrote on Sat, 01 December 2012 14:44

I'm using a SqlArray together with Sqlite.

I am not familiar with either of these but you may need to format the Date at start up.

I have 5 formats for distance: feet, miles, meters, kilometers and nautical miles.
Three for angle format: decimal degrees, degrees minutes and degree minutes seconds
Five for number of decimal places.

Whatever code you have to get the 01/12/2012 format that code needs to be run through on start up and whenever the date is updated.

Note near the bottom 'Save > Exit'
This saves all the settings in a .cfg file that is run through at start up.

The line above that 'Save Location' if checked will save the latitude, longitude, alt/zoom, heading and pitch.


The U++ app and also the java globe app will be opened as it was on exit.

edit: That is like TheIDE used to be rather than opening in Full Screen.

[Updated on: Sun, 02 December 2012 08:22]

Report message to a moderator

Re: Weird Date bevaviour in Sqlite [message #38349 is a reply to message #38122] Wed, 12 December 2012 01:23 Go to previous message
Alboni is currently offline  Alboni
Messages: 214
Registered: January 2012
Location: Deventer, Netherlands
Experienced Member
SetDateFormat("%3:02d/%2:02d/%1:4d"); // set dd/mm/yyyy format
SetDateScan("dmy"); // same but for input


Previous Topic: SQL_MySql reference example only compiles in debug mode
Next Topic: Fields of the same name in diff tables
Goto Forum:

Current Time: Sun Jul 14 12:39:16 CEST 2024

Total time taken to generate the page: 0.02123 seconds