How to get from smalldatetime -field only date?

Microsoft SQL Server


I'm using MSDE 2000 SP4. I need to get only date from smalldatetime
using SQL statement like "SELECT MyDate FROM MyTable.".

regional settings, but how to get just "27.11.2005" without that empty time?

I think this is quite easy to solve.
You have to use the CONVERT Function to dispaly it in the proper way:

HTH, jens Suessmeyer.
Jens kirjoitti:
Nice, thanks Jens!

Is there a link where those different form numbers like 103 is
described? Looks like 104 is like finnish form of date, which I just
Look int he BOL which is delivered within SQL Server or use the online

HTH, Jens Suessmeyer.