<div>
use date_format() function to format the output to the date part only<br />
<a href="http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html" rel="ugc">http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html</a>
</div>


use date_format() function to format the output to the date part only
http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html [http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html]

<div>
hi thanks for thereply<br />
i have looked at your url however the things its discussing there are way above my ability to understand i curently have<br />
select distinct `date_purchased` from orders WHERE `bookedby` = 'Internet Order' order by `date_purchased`<br />
<br />
the date purchased colum has data like: 2006-08-29 11:22:08 im guessing a trim or soumthing like that needs to be done first?<br />
can you give me an example?
</div>


hi thanks for thereply
i have looked at your url however the things its discussing there are way above my ability to understand i curently have
select distinct `date_purchased` from orders WHERE `bookedby` = 'Internet Order' order by `date_purchased`

the date purchased colum has data like: 2006-08-29 11:22:08 im guessing a trim or soumthing like that needs to be done first?
can you give me an example?

<div>
thans verry mutch i see what the url was going on about now
</div>


thans verry mutch i see what the url was going on about now

<div>
<div class="content wysiwyg-content">
hi i wish to select distinct from a colum that has data like this:2006-08-29 11:22:08 but i only want to select distinct on the date part not the time aswell please show me how to atchive this thanks
</div>
</div>


hi i wish to select distinct from a colum that has data like this:2006-08-29 11:22:08 but i only want to select distinct on the date part not the time aswell please show me how to atchive this thanks

MySQL Select Distinct

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.