Re: Date Format on a timestamp field

looks like a datetime field - which holds time of insert (timestamp might as well) --Joe On Mon, Nov 27, 2000 at 11:51:21PM -0800, davey sonya wrote: > Hi I'm new to PHP > Was wondering if anyone can help me with adjusting a > timestamp field in the database to a date > format(d/m/Y). > This is what I have so far: > > <? echo > date("d/m/Y",$GetApplicationDetailRow[$IndApplicationDate]);?> > This does not give me an error message, but rather > gives me the date value of:01/01/1970 > which should actually hold the date value:08/05/2000 > from a field in the database. > > And this:<? echo > $GetApplicationDetailRow[$IndApplicationDate];?> gives > me the right value but in the wrong format > ie:08/05/2000 00:00:00 > > Thanks in advance. > Lindie > > __________________________________________________ > Do You Yahoo!? > Yahoo! Shopping - Thousands of Stores. Millions of Products. > http://shopping.yahoo.com/ > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net ================================================================================ = Joe Stump joestump98@yahoo.com http://www.miester.org = ================================================================================ Need a programmer? http://www.google.com/search?q=joe+stump+resume