>>>>>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 ;-)

CONVERT(VARCHAR(8),dt.currentdate, 1)+' '+convert(varchar(5), dt.currentdate, 108) does it for me . Must be a slow day in Eastern Europe.