>>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?