RE: dates PHP4 and Access

---------------------------------------------------------------------------- ----------------- Disclaimer: The information contained in this email is intended only for the use of the person(s) to whom it is addressed and may be confidential or contain legally privileged information. If you are not the intended recipient you are hereby notified that any perusal, use, distribution, copying or disclosure is strictly prohibited. If you have received this email in error please immediately advise us by return email at postmaster@normandy.com.au and delete the email document without making a copy. ---------------------------------------------------------------------------- ----------------- Look up date formats in your Access help (Im using Office 98 or whatever) SELECT documents.doc_id, documents.date_created, format(documents.date_created,"Long Date") as formatted_date, format(documents.date_created,"h:m:s") as formatted_date1, format(documents.date_created,"hh:mm:ss AMPM") as formatted_date2, format(documents.date_created,"dddd, mmm d yyyy") as formatted_date3 FROM documents; Hope this helps, mn -----Original Message----- From: Quintin Blane [mailto:qablane@surfaid.org] Sent: Wednesday, July 05, 2000 3:46 AM To: php-windows@lists.php.net Subject: dates PHP4 and Access I require to report via PHP4 dates acquired from Access 2000 via ODBC How do I convert the output to a meaningful date? With no parameter the Date() function gives me current date and time; with the date output of ODBC I get what I take to be the start date for counting dates in PHP. Quintin A Blane