Dear Experts,

I have a problem with formating a timestamp field which is retrieved from postgresql timestamp field.

When I print the value it shows as below:

echo $result['adddate'];

Mon 18 Aug 02:06:33.825621 2003

They way I want it is just Mon 18 Aug 2003.

I have tried with

echo date( 'l, d, n, Y', strtotime($result['adddate']));

Thursday, 01, 1, 1970

It prints invalid date. How do I format the date?

Please help.

Regards,
ganesh

My first suggestion is to rewrite your query to return something you can use. If that's not an option, you'll need to extract the pieces yourself using regular expressions or some similar approach.

For example:

$pattern = '/(\w+)\s+(\d+)\s+(\w+)\s+[\d:\.]+\s+(\d+)/';
$replace = '${1} ${2} ${3} ${4}
echo preg_replace($pattern, $replace, $result['adddate']);

*should* print "Mon 18 Aug 2003".



Take care,

Nik
http://www.bigaction.org/

Thanks a lot, it works.