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 » 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
Hi!
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 &...
Contributor
lectus wrote on Sat, 01 December 2012 14:44

Hi!
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.

index.php?t=getfile&id=3957&private=0

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: 183
Registered: January 2012
Location: Deventer, Netherlands
Experienced Member
GUI_APP_MAIN
{
SetDateFormat("%3:02d/%2:02d/%1:4d"); // set dd/mm/yyyy format
SetDateScan("dmy"); // same but for input

............etc



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: Tue Dec 10 07:36:29 CET 2019

Total time taken to generate the page: 0.01453 seconds