U++ forum: Welcome to the forum

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