>>>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?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.