MySQL date

[Remorse]

Why when I lf a date to display on my website its displayed like this : 1551181916

                                                                                                                                         POST                 USER             DATE

• Class balance system | Remorse | 1551181916

 

I'm trying to find information from mysql

 

To show : last active post and the username and date any help? ssql query 

[Adriano Faria]

On a template:

{datetime="$date"}

PHP:

$myDate = \IPS\DateTime::ts( $date );

 

[Remorse]

We want to show it on our website not in forum

[Adriano Faria]

http://php.net/manual/en/function.date.php

[Remorse]

This are my 10 recently posts on forum.

 

 

I want to do the same info, and share it on my website like the 10 last active posts

[Remorse]

any advice wich sql querys to use to show last 10 active topics?

[bfarber]

If you have Pages, I would recommend simply creating a custom block in pages and then using the existing "Embed externally" feature, which will give you some javascript code you can insert into your website to display the block.

To answer your original question, what is stored is known as a timestamp, and the PHP date function (among others, such as strftime) can convert that to a human-readable date.