Hello,
when i add a date in custom field date the format changes, for example when i add: 2015-03-23 i find in database in mantis custom field string this value: 2343434 how i can get the format correctly ? mantis uses a specil function to save the date field in table ?
Date Format in Mysql
Moderators: Developer, Contributor
-
- Posts: 49
- Joined: 24 Mar 2015, 22:41
Re: Date Format in Mysql
i have founded it, Mantis uses this function date('Y-m-d H:i:s' 6323944) to show datetime in the pages
Re: Date Format in Mysql
Hi Mmarouane89!
Can you describe for me what it looks like is MySQL script?
so It does not work
Thank you
Can you describe for me what it looks like is MySQL script?
so
Code: Select all
select function date ('Y-m-d'date_submitted )from mantis_bug_table
Thank you
-
- Posts: 49
- Joined: 24 Mar 2015, 22:41
Re: Date Format in Mysql
In MySQL i get the value and i use a php function; for example: Select date from ...
$date = date('d-m-Y', $row[0]);
$date = date('d-m-Y', $row[0]);