PHP Zend date format

php zend-framework date zend-date formatdatetime
maniclorn picture maniclorn · Jun 1, 2011 · Viewed 43.7k times · Source

I want to input a timestamp in below format to the database.

yyyy-mm-dd hh:mm:ss

How can I get in above format?

When I use 

$date = new Zend_Date();

it returns month dd, yyyy hh:mm:ss PM

I also use a JavaScript calender to insert a selected date and it returns in dd-mm-yyyy format

Now, I want to convert these both format into yyyy-mm-dd hh:mm:ss so can be inserted in database. Because date format not matching the database field format the date is not inserted and only filled with *00-00-00 00:00:00*

Thanks for answer

Answer

stefgosselin picture stefgosselin · Jun 1, 2011

Not sure if this will help you, but try using:

 // to show both date and time,
 $date->get('YYYY-MM-dd HH:mm:ss');

 // or, to show date only
 $date->get('YYYY-MM-dd')

Related questions

How to compare the date parts of two Zend_Date objects?

I'd like to check if to Zend_Date datetimes are on the same day. How can I do that? $date1 = new Zend_Date('2011-11-14 10:45:00'); $date2 = new Zend_Date('2011-11-14 19:15:00');

Read More
Inserting current date to MySql using Zend Date

I have a website based on Zend Framework. There is a form for users to fill in and the entered data is inserted in the database. The users don't enter the date/time. I would like to populate the data …

Read More
how to create virtual host on XAMPP

I am sure this question is being asked many times but I am not encounter with a problem. I am using XAMPP where I configure Zend framework. XAMPP is running on port 8081 as 80 is being occupied by some Windows process …

Read More