2. PHPRunner General questions
  3. mySQL date format
This topic is locked

mySQL date format

 		12/29/2008 9:21:08 AM
PHPRunner General questions
C
 chorus author

Hi,
Im pretty new on mysql/php/phprunner etc... so excuse me if this sounds a bit silly :
How can I change the format of the date when its been showed?

At the moment my dates are YYYYMMDD and I would like them to be DDMMYYYY. (note: I use PHPrunner)
thanks in advance,

Regards
J
 		Jane 12/30/2008

Hi,
what format do you use on the "View as" settings dialog on the Visual Editor tab?
C
 		chorus author 12/30/2008

Hi,

what format do you use on the "View as" settings dialog on the Visual Editor tab?


Hi Jane,
No matter what format I select, it stays YYYYMMDD. (can it be that it is related to mySQL?)
A
 		Astrid 12/31/2008

Did you try to change format in locale.php?
C
 		chorus author 12/31/2008

Did you try to change format in locale.php?


No, I have not tried that. I just checked locale.php and there is quite a bit of text inthere <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=36384&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />

Any tip on where to change it in locale.php?
Regards
J
 		Jane 1/5/2009

Hi,
PHPRunner do not change field values. Check your values in the database directly.

Also you can re-format values using custom format on the "View as" settings dialog on the Visual Editor tab.

Here is a sample:

$value = date("dmY",strtotime($value));