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

never was asked - it might be needed for grouping on minutes, so the spanking might make "layered" sense ;-)