title: Select time from datetime in SQL Compact
body: <p>Much like this question: "<a href="https://stackoverflow.com/questions/7710449/how-to-get-time-from-datetime-format-in-sql">How to get Time from DateTime format in SQL?</a>", I am trying to select <em>only</em> the time from a datetime, but unlike the above question,  I would like to know how to do it in <code>SQL Server Compact</code>. Does anyone know how to do this?</p>