This is a discussion on Getting date from database table within the MySQL forums, part of the Database Server Software category; --> Hai every body. I have a problem.In my mysql database iam having a table logintable. In that i am ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |
| Thread Tools | |
| Display Modes | |
|
|