U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » Community » Newbie corner » Formatting a date in a sqlArray column

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

Formatting a date in a sqlArray column [message #45147]

Wed, 16 September 2015 16:55

Giorgio
Messages: 218
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

Report message to a moderator

Re: Formatting a date in a sqlArray column [message #45177 is a reply to message #45147]

Wed, 23 September 2015 09:37

Giorgio
Messages: 218
Registered: August 2015

Experienced Member

Report message to a moderator

Re: Formatting a date in a sqlArray column [message #45223 is a reply to message #45147]

Sat, 10 October 2015 00:19

Alboni
Messages: 214
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Apr 18 03:33:27 CEST 2024

Total time taken to generate the page: 0.02024 seconds