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