converting datetime format

[toonz]

I have added a line item on one of my .tpl pages to show the date. since it is pulling the datetime stamp from the db, it shows a date like 1226325111 right now. since the info is being pulled from

 

<td><B>{$ctoninfo.release_date}</B> </td>

 

how do I alter the code to only display the date formatted to 'mm-dd-yyyy'?

 

thanks in advance

[jscix]

SELECT DATE_FORMAT(CURDATE(), '%d/%m/%Y')

[PFMaBiSmAd]

If your column in your database holds a Unix Timestamp, you can convert and format it using the mysql FROM_UNIXTIME(unix_timestamp,format) function in your query. Use the same format string that jscix gave in the DATE_FORMAT example.

 

Ref: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_from-unixtime

[toonz]

so how/where do I insert it into the string

 

{$ctoninfo.release_date}

 

thanks

[PFMaBiSmAd]

You don't. You do that in your mysql SELECT query that is retrieving the data from the database.

[toonz]

ah, well since I have 0 experience coding php, I dont think I will be altering the php file. I have only been working on the ptl files to change layouts and formatting

[toonz]

ok, say I add this line towards the top of the php file

 

$str_sql = "select DATE_FORMAT(FROM_UNIXTIME(release_date), '%m/%d/%Y')";

 

in the tpl file, I changed the target from

 

{$ctoninfo.release_date}

 

to

 

{$release_date}

 

now instead of pulling up a datetime string of numbers, it gives a blank space. how do I make it so that template knows to pull the newly converted timestamp from the php file?

 

thanks again

 

[Mchl]

Are you using Smarty?

[PFMaBiSmAd]

You would not change {$ctoninfo.release_date} in the template, you would change the existing code that queries the database and places the content into that variable.

[Mchl]

In smarty you could actually use date_format modifier.

 

That's one of the ideas behind templates. Template designer does not have to (should not!) modify database code.

[toonz]

yes, from the looks of the code there is smarty. I see a row like

 

$smarty->assign("toon_path",$tpth);

 

 

so how do have the tpl pull the newly formatted date into the actual template to display on the web page? thanks

[Mchl]

{$ctoninfo.release_date|date_format:"%m-%d-%Y"}

[toonz]

Mchl, youre brilliant! worked like a charm. thanks