I've added a timestamp field to a table and when viewing the data stored in the field it looks like this .....
19970523091528 ...... but when I view the data in Access or Macromedia Dreamweaver it looks like this .... 05/23/1997 09:15:28 ...... is there any way to make Access/Dreamweaver display the timstamp field using the first format ?. Thanks. Clive Arnold - IT Co-ordinator White and Bowker Solicitors. *********************************************************************** Confidentiality: This e-mail message and any attachments may contain confidential and/or legally privileged information. It is intended for the addressee only and if you are not the intended recipient you should not copy or use the contents nor disclose them to anybody else. In such a case please notify the sender by return e-mail immediately and delete this message and its attachments together with all copies in whatever form. Security: In the case of a client contacting White and Bowker by e-mail, White and Bowker will assume that they have the clients' implied consent to communicate (with the client) using e-mail, in the clients full knowledge that e-mail is not a secure mode of communication. Business Use: Any views or opinions expressed in this message (and any attachments) that do not relate to the official business of White & Bowker are neither given nor endorsed by it. Viruses: This e-mail and any attachments has been checked for viruses using Guinevere but White & Bowker accepts no responsibility for any viruses not revealed by such check and in accordance with good computing practice recipients should ensure that they are actually virus free. In case of any query relating to this message or its content please contact the Sender or the System Manager by return e-mail or telephone +44 (0)1962 844440 or by post at White & Bowker 19 St. Peter Street Winchester SO23 8BU United Kingdom *********************************************************************** --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php