How to retrieve the date that database item is published and updated

[sobrenome]

On custom database template, date is parsed by:

{datetime="$record->record_publish_date"}

Which results in:

<time datetime="2013-09-21T03:42:47Z" title="09/21/2013 12:42  AM" data-short="Sep 13">21 Sep 2013</time>

I want to retrieve only the straight date of publishing and updating in this format:

2009-05-08

It's for micro data purposes.

Anyone can help? Thanks.

[sobrenome]

Anyone?

[Wayne B]

{datetime="$record->record_publish_date"|raw}

try this

[sobrenome]

It gives something like this:

1408594320

But how to get like this:

2009-05-08

 

[BomAleold]

It gives something like this:

1408594320

But how to get like this:

2009-05-08

 

try with {date="..." dateonly="true"}

http://community.invisionpower.com/4docs/advanced-usage/development/template-tags-r76/

 

 

 

 

[sobrenome]

Almost there! Now it gives:

 

08/21/2014

 

[opentype]

If you want a custom date output in just one place, you would need to run the Unix timestamp (e.g. “1408594320”) through PHP’s date function. 

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

[sobrenome]

Thanks!

and how to get the updated date?

[sobrenome]

Works great:

{{$datePublished = date ("Y-m-d", $record->record_publish_date);}}
          <meta itemprop="datePublished" content="{$datePublished}">

What about date updated?

[opentype]

Those are all the date fields:

• record_publish_date
• record_saved
• record_updated
• record_last_comment
• record_last_review
• record_edit_time

[sobrenome]

Thanks!! Is there any documantation about?

[opentype]

I looked it up in phpMyAdmin. It’s just the names of the actual database columns. 

[sobrenome]

Perfect!