Check out the PHP manual on date formatting: http://us2.php.net/date Jim -------Original Message------- From: Harpreet Date: Wednesday, September 17, 2003 02:36:49 PM To: php-windows@lists.php.net Subject: Re: Date question? I have a field in my sql server called expiration which is of type datetime. It has values as seen in the tables and query analyser as 1/1/01 2:11:11 PM When i try to display the same value in a php page it shows as Jan 1 2001 2:11PM How can i view the same format as seen the database on my php page. Please help.I cannot find anything in the manual. thanks -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php .