I think you can use something like:
"Salim Afþar" <safsarluckyeye.com> wrote in message
> How can I cast from datetime type to smalldatetime type.
> I get the records from a table which has got a datetime type column but I
> want to display it smalldatetime format.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system ([url]http://www.grisoft.com[/url]).
Version: 6.0.505 / Virus Database: 302 - Release Date: 30/07/2003