>>>No, the poitn is not force SQL Server to return what you want, bnut to SHOW that DT field in the format you want.
>>>

>>>DateTime.ToString("dd/MM/yy hh:mm");
>>>

>>
>>I'm missing the difference completely I'm afraid. The date is stored as datetime and i'm showing the format I want.
>
>Showing is the province of the presentation layer, i.e. whatever generates your html. SQL is rather far behind the scenes and shouldn't have to care about formatting.
>
>In that part it's true that you're showing the format you want - it's just that as homo multiplex (or multi-tier) you need to decide which one of yous is in charge of formatting - you presenter or you data cruncher?

Thanks dragan I have to say its still so much semantics to me. :-)