From: Jorge Bastos Date: April 16 2008 9:44pm Subject: RE: Date Column Format List-Archive: http://lists.mysql.com/win32/18870 Message-Id: <00be01c8a00b$1a2f21c0$4e8d6540$@jorge@decimal.pt> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit That is saved in a datetime column, to display in that format you have to format it: Check the function date_format() in the manual. > -----Original Message----- > From: Roger Reid [mailto:rocketcreator@stripped] > Sent: quarta-feira, 16 de Abril de 2008 22:39 > To: win32@stripped > Subject: Date Column Format > > All, > > When creating a table with the below date format, how would you, or > what > format would be used to create a column for the below date? > > Example: > > 4/16/2008 1:05 PM