RE: [PHP] Hi How to convert the time from mysql(DATETIME) table to the format DD/MM/YYYY HH:MM AM or PM in PHP?
Hi, I already have the date in mysql (DATETIME)format in variable called $start_date. I would like to convert that in to the form DD/MM/ HH:MM AM or PM. Thanks in advance. -Balaji -Original Message- From: Faisal Abdullah [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 7:04 AM To: Balaji Ankem; 'Php-General' Subject: Re: [PHP] Hi How to convert the time from mysql(DATETIME) table to the format DD/MM/YYYY HH:MM AM or PM in PHP? Try date("d/m/Y h:m A"); On Tuesday 12 March 2002 18:29, Balaji Ankem wrote: > Hi, > I have stored the date and time in mysql table with DATETIME type. > > I want to change it in to DD/MM/ HH:MM AM or PM. > > How can I do this? > > Thanks in advance > Balaji -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php **Disclaimer Information contained in this E-MAIL being proprietary to Wipro Limited is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Hi How to convert the time from mysql(DATETIME) table to the format DD/MM/YYYY HH:MM AM or PM in PHP?
Try date("d/m/Y h:m A"); On Tuesday 12 March 2002 18:29, Balaji Ankem wrote: > Hi, > I have stored the date and time in mysql table with DATETIME > type. > > I want to change it in to DD/MM/ HH:MM AM or PM. > > How can I do this? > > Thanks in advance > Balaji -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Hi How to convert the time from mysql(DATETIME) table to the format DD/MM/YYYY HH:MM AM or PM in PHP?
You have to parse your dates in anyway you like best to pieces, then use mktime() and then date() function. :) Niklas -Original Message- From: Balaji Ankem [mailto:[EMAIL PROTECTED]] Sent: 12. maaliskuuta 2002 12:35 To: [EMAIL PROTECTED]; 'Php-General' Subject: RE: [PHP] Hi How to convert the time from mysql(DATETIME) table to the format DD/MM/YYYY HH:MM AM or PM in PHP? Thankyou for reply!! I want to do it in PHP. Thanks in advance Balaji -Original Message- From: Niklas Lampén [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 4:04 PM To: Php-General Subject: RE: [PHP] Hi How to convert the time from mysql(DATETIME) table to the format DD/MM/YYYY HH:MM AM or PM in PHP? Do you want to do this in mySQL or PHP? Niklas -Original Message- From: Balaji Ankem [mailto:[EMAIL PROTECTED]] Sent: 12. maaliskuuta 2002 12:30 To: 'Php-General' Subject: [PHP] Hi How to convert the time from mysql(DATETIME) table to the format DD/MM/ HH:MM AM or PM in PHP? Hi, I have stored the date and time in mysql table with DATETIME type. I want to change it in to DD/MM/ HH:MM AM or PM. How can I do this? Thanks in advance Balaji -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Hi How to convert the time from mysql(DATETIME) table to the format DD/MM/YYYY HH:MM AM or PM in PHP?
> Hi, > I have stored the date and time in mysql table with DATETIME > type. > > I want to change it in to DD/MM/ HH:MM AM or PM. > > How can I do this? When you select the 'datetime' field from mysql use UNIX_TIMESTAMP(). Then in PHP use strftime() to format the 'datetime' field to your liking. -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk /* Happiness isn't something you experience; it's something you remember. -- Oscar Levant */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Hi How to convert the time from mysql(DATETIME) table to the format DD/MM/YYYY HH:MM AM or PM in PHP?
Thankyou for reply!! I want to do it in PHP. Thanks in advance Balaji -Original Message- From: Niklas Lampén [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 4:04 PM To: Php-General Subject: RE: [PHP] Hi How to convert the time from mysql(DATETIME) table to the format DD/MM/ HH:MM AM or PM in PHP? Do you want to do this in mySQL or PHP? Niklas -Original Message- From: Balaji Ankem [mailto:[EMAIL PROTECTED]] Sent: 12. maaliskuuta 2002 12:30 To: 'Php-General' Subject: [PHP] Hi How to convert the time from mysql(DATETIME) table to the format DD/MM/ HH:MM AM or PM in PHP? Hi, I have stored the date and time in mysql table with DATETIME type. I want to change it in to DD/MM/ HH:MM AM or PM. How can I do this? Thanks in advance Balaji -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php **Disclaimer Information contained in this E-MAIL being proprietary to Wipro Limited is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Hi How to convert the time from mysql(DATETIME) table to the format DD/MM/YYYY HH:MM AM or PM in PHP?
Do you want to do this in mySQL or PHP? Niklas -Original Message- From: Balaji Ankem [mailto:[EMAIL PROTECTED]] Sent: 12. maaliskuuta 2002 12:30 To: 'Php-General' Subject: [PHP] Hi How to convert the time from mysql(DATETIME) table to the format DD/MM/ HH:MM AM or PM in PHP? Hi, I have stored the date and time in mysql table with DATETIME type. I want to change it in to DD/MM/ HH:MM AM or PM. How can I do this? Thanks in advance Balaji -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php