How to get from smalldatetime -field only date?

Microsoft SQL Server

Hi!

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
guessed.
Look int he BOL which is delivered within SQL Server or use the online
BOL:

http://msdn.microsoft.com/library/en-us/tsqlref/ts_ca-co_2f3o.asp

HTH, Jens Suessmeyer.