>>>>>>Hi all
>>>>>>
>>>>>>I have a date time and I want to return it in a query as dd/mm/yy and the time as 24 hour hours and minutes only
>>>>>>
>>>>>>so as an example 17/02/14 15:20
>>>>>>
>>>>>>any ideas what the best way to do that is ?
>>>>>>
>>>>>>Thanks
>>>>>
>>>>>It is a FrontEnd job to format DateTime type the way you want.
>>>>
>>>>Thanks Boris
>>>>
>>>>I'll put that in my little book of useless replies. :-)
>>>>
>>>>I think its your first entry.
>>>>
>>>>this is an sql command embedded in a classic asp page. What layer does that count as ?
>>>
>>>In your ASP page you should care HOW DateTime should be presented, not on SQL Server side.
>>>What if you have more than one regional settings?
>>>What if someone want to see this page in other format like dd.MM.yyyy hh:mm?
>>
>>As the sql is in the asp page I think that takes care of that.
>>
>>For this I don't have regional settings
>>
>>No one except the people who have asked for the format is ever going to look a this.
>
>
>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.