-
- 206 Posts
Dear All,
I need to display the publication date from my database.
The problem is the following.
On the table "modx_site_content" I saw the filed "publishedon". But the filed containe number as "1322423220". But it is not a date.
I need to extract that data with a snipest and I have no idea how can I use my sql request to convert it to the correct format.
Any idea?
Thank
Or use the API properly and it will return a formatted date for you.
-
- 206 Posts
Thank to all,
I got the answer with date()
But may be could let me know how to do with API?