Hai every body.
I have a problem.In my mysql database iam having a table logintable.
In that i am having a field like log_time. When ever i want to
retrieve the info from log_time field it gives the below result;
+---------------------+
| log_time |
+---------------------+
| 2007-08-06 14:24:11 |
+---------------------+
O.K.But i want to retrieve the data in complete date format like
"August 6th 2007 14:24:11 pm".
Please respond as as early as possible.
Thank You

On 8 Aug, 07:15, php.a...@gmail.com wrote:
> Hai every body.
> I have a problem.In my mysql database iam having a table logintable.
> In that i am having a field like log_time. When ever i want to
> retrieve the info from log_time field it gives the below result;
> +---------------------+
> | log_time |
> +---------------------+
> | 2007-08-06 14:24:11 |
> +---------------------+
> O.K.But i want to retrieve the data in complete date format like
> "August 6th 2007 14:24:11 pm".
> Please respond as as early as possible.
> Thank You

http://dev.mysql.com/doc/refman/5.0/...on_date-format