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 » Community » Newbie corner » Formatting a date in a sqlArray column
Formatting a date in a sqlArray column [message #45147] Wed, 16 September 2015 16:55 Go to next message
Giorgio is currently offline  Giorgio
Messages: 207
Registered: August 2015
Experienced Member
Hi there,
this should be super-easy, but I am strolling around without finding a solution. I have a sqlArray connected to a MySql database. One of the column is (in MySQl RDBMS) a DATETIME type. When showing data the date is in American format: month/day/year hour:min:sec. I just want that column in European format: day/month/year hour:min:sec. That's where I am:

arrProd1.AddColumn(INIZIO, "Inizio",5).SetConvert();


But I am stuck because I do not know what to put in the SetConver parenthesis.
Thanks in advance for any help.
Ciao,
Giorgio
Re: Formatting a date in a sqlArray column [message #45177 is a reply to message #45147] Wed, 23 September 2015 09:37 Go to previous messageGo to next message
Giorgio is currently offline  Giorgio
Messages: 207
Registered: August 2015
Experienced Member
Up
Re: Formatting a date in a sqlArray column [message #45223 is a reply to message #45147] Sat, 10 October 2015 00:19 Go to previous message
Alboni is currently offline  Alboni
Messages: 203
Registered: January 2012
Location: Deventer, Netherlands
Experienced Member
You don't need a convert for this, setting the language correct is usually enough:

GUI_APP_MAIN
{
	SetLanguage(LNGFromText("IT-IT"));



if that doesn't do it try:
GUI_APP_MAIN
{
   SetDateFormat("%3:02d/%2:02d/%1:4d"); 
   SetDateScan("dmy");

[Updated on: Sat, 10 October 2015 00:39]

Report message to a moderator

Previous Topic: Targeting platforms
Next Topic: [SOLVED] Install to debian or build - I need help
Goto Forum:
  


Current Time: Sun Jan 24 08:59:56 CET 2021

Total time taken to generate the page: 0.01448 seconds