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?

2002-03-12 Thread Niklas Lampén
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,

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?

2002-03-12 Thread Balaji Ankem
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

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?

2002-03-12 Thread Jason Wong
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'

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?

2002-03-12 Thread Niklas Lampén
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

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?

2002-03-12 Thread Faisal Abdullah
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

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?

2002-03-12 Thread Balaji Ankem
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,