Date Format in SQL Statement

[mikewin86]

Hello,


I would like to ask a question.

How can I format the Date Value in SQL Statement like this?

SELECT Format(OrderDat e,"MMM-yyyy") etc


In vb.net we can format Date Value like this.

Format(OrderDat e,"MMM-yyyy")

Thanks in advance

Mike

[Jerry Winston]

Try this:

MSDN

[ck9663]

It's always recommended to do the formatting in the front-end, not the back end...

Good Luck!!!

~~ CK

[NeoPa]

That particular format is not supported by CONVERT(). You will probably need to use something like :

SELECT CONVERT(nvarchar(3), [OrderDate], 109) + '-' + CAST(YEAR([OrderDate])) AS nvarchar(4)) AS [YourFieldName]

As CK says though, in most circumstances this is better done by the client than the SQL Server (IE. Don't do it in the SQL at all).

[mikewin86]

Thanks NeoPa.

It work well with my query.

Thanks all for your suggestions.

[NeoPa]

That's fine Mike. Glad to help. I guess you went for the SQL version in the end then. Only you can know your full requirements. We can only advise.