General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2008 R2
>>>>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 ;-)
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only