Entry

How to convert Date/Timestamp from a wwwthreads(perl newsboard) mysql database to human readable format?

Dec 3rd, 2001 08:03
ditoiu cristian, Chris Esler,

SELECT id,DATE_FORMAT(HeureLimite,'%Y %D %M %h:%i:%s %x') 
AS data 
FROM nbconecte;
ex : 
table
id->int(5)
your_time_field->timestamp(14)
------
mysql> select id,DATE_FORMAT(your_time_field,'%Y %D %M %
    ' h:%i:%s %x') as data from nbconecte;
+----+---------------------------------+
| id | data                            |
+----+---------------------------------+
| 1  | 2001 3rd December
h:17:11 2001 |
| 1  | 2001 3rd December
h:17:11 2001 |
| 1  | 2001 3rd December
h:17:14 2001 |
| 1  | 2001 3rd December
h:17:15 2001 |
| 1  | 2001 3rd December
h:17:28 2001 |
| 1  | 2001 3rd December
h:17:30 2001 |
| 1  | 2001 3rd December
h:12:46 2001 |
| 1  | 2001 3rd December
h:09:47 2001 |
| 1  | 2001 3rd December
h:09:48 2001 |
| 1  | 2001 3rd December
h:12:07 2001 |
| 2  | 2001 3rd December
h:12:17 2001 |
| 1  | 2001 3rd December
h:09:54 2001 |
| 1  | 2001 3rd December
h:10:26 2001 |
| 1  | 2001 3rd December
h:11:49 2001 |
| 2  | 2001 3rd December
h:10:27 2001 |
| 2  | 2001 3rd December
h:10:51 2001 |
| 2  | 2001 3rd December
h:10:59 2001 |
| 1  | 2001 3rd December
h:10:45 2001 |
| 2  | 2001 3rd December
h:12:16 2001 |
| 1  | 2001 3rd December
h:12:42 2001 |
| 2  | 2001 3rd December
h:11:58 2001 |
| 1  | 2001 3rd December
h:12:09 2001 |
| 1  | 2001 3rd December
h:12:09 2001 |
+----+---------------------------------+
23 rows in set (0.01 sec)
-----
an then you reference the date field as 'data' (because of --select ... 
AS data)