<div>
<br />
a) Try double-quotes: &lt;?php echo date(&quot;d/m/Y&quot;,strtotime($ro<wbr />w_rsOrden[<wbr />'sol_fecha<wbr />'])); ?&gt;<br />
b) Echo just the $row_rsOrden['sol_fecha'],<wbr /> see what it gives you<br />
c) What type of server are you running this on?
</div>



a) Try double-quotes: <?php echo date("d/m/Y",strtotime($row_rsOrden['sol_fecha'])); ?>
b) Echo just the $row_rsOrden['sol_fecha'], see what it gives you
c) What type of server are you running this on?

<div>
If its already a timestamp in the database then why are you using strtotime?<br />
<br />
&lt;?php echo date('d/m/Y',$row_rsOrden[<wbr />'sol_fecha<wbr />']); ?&gt;<br />
<br />
<br />
31/12/1969 will be one second before the unix epoch, you usually get this when dealing with an invalid timestamp or an empty timestamp
</div>


If its already a timestamp in the database then why are you using strtotime?

<?php echo date('d/m/Y',$row_rsOrden['sol_fecha']); ?>


31/12/1969 will be one second before the unix epoch, you usually get this when dealing with an invalid timestamp or an empty timestamp

<div>
Thanks to all who responded. I got it working with minichicken's suggestion.
</div>


Thanks to all who responded. I got it working with minichicken's suggestion.

<div>
Sorry, grammar turned bad for a second there... :p<br />
<br />
I mean, I am gald that it worked for you :)
</div>


Sorry, grammar turned bad for a second there... :p

I mean, I am gald that it worked for you :)

<div>
$isay = $row_Cecilia['understood']<wbr />;<br />
<br />
=)
</div>


<div>
<div class="content wysiwyg-content">
Hello<br />
<br />
I have a timestamp field on my MySQL DB but I can't get it to show the right way on my pages. <br />
<br />
Taking an example from my DB:<br />
<br />
TIMESTAMP filed shows: 20040929064953 &nbsp;which is correct <br />
<br />
This is the PHP code I am using to format it on my pages:<br />
<br />
&lt;?php echo date('d/m/Y',strtotime($ro<wbr />w_rsOrden[<wbr />'sol_fecha<wbr />'])); ?&gt;<br />
<br />
but I get<br />
<br />
31/12/1969 instead of 29/09/2004<br />
<br />
am I missing something?<br />
<br />
Thanks<br />
<br />
Cecilia<br />

</div>
</div>


Hello

I have a timestamp field on my MySQL DB but I can't get it to show the right way on my pages. 

Taking an example from my DB:

TIMESTAMP filed shows: 20040929064953  which is correct 

This is the PHP code I am using to format it on my pages:

<?php echo date('d/m/Y',strtotime($row_rsOrden['sol_fecha'])); ?>

but I get

31/12/1969 instead of 29/09/2004

am I missing something?

Thanks

Cecilia


Date format for a TIMESTAMP field

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.