[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 117
  • Last Modified:

reverse the date in find

Hi, In cakephp how can I get the date in reverse order as when I add this to a select input box I see the date as Y-m-d.
The database stores the date in this order.
In the find I want to have the date formatted before assigning to a select box.

  $dateoptions=$this->Lesson->find('list', array(
               'fields' => array('Lesson.lesson_date')  ));
0
jagguy
Asked:
jagguy
  • 4
  • 3
1 Solution
 
Ray PaseurCommented:
Not sure about the "Cake" part, but in PHP we use strtotime() and date() functions to reformat dates.
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_201-Handling-date-and-time-in-PHP-and-MySQL.html

Example:

<?php
$today = '2014-10-08';
$timestamp = strtotime($today);
$pretty_date = date('F j, Y', $timestamp);

Open in new window

0
 
jagguyAuthor Commented:
The cake part is the MVC and this is important.
I meant getting the date reversed in the find itself
0
 
Ray PaseurCommented:
I understand that Cake is the MVC framework.  I don't think you can do the date "reversal" in the find().  It's a bit of an exploratory process, but if you work with me we can get a good solution.  After this function call, please add var_dump() as shown here.  Use "view source" to see the output from var_dump().  Copy it and post it back here, thanks.  Also, please tell me the format you want to see for the date.

$dateoptions=$this->Lesson->find('list', array(
               'fields' => array('Lesson.lesson_date')  )); 
var_dump($dateoptions);

Open in new window

0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
jagguyAuthor Commented:
sorry I have been away for w awhile so I will get on to it
0
 
jagguyAuthor Commented:
$sdate= date('d-m-Y',(strtotime( $sdate )));
echo $sdate;
0
 
Ray PaseurCommented:
Are you sure there was nothing in this comment that helped you?
http://www.experts-exchange.com/Programming/Languages/Scripting/PHP/Q_28534478.html#a40370640
0
 
jagguyAuthor Commented:
i found the answer
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now