[sql-server-2008] How to get a particular date format ('dd-MMM-yyyy') in SELECT query SQL Server 2008 R2

select CONVERT(NVARCHAR, SYSDATETIME(), 106) AS [DD-MON-YYYY]

select REPLACE(CONVERT(NVARCHAR,GETDATE(), 106), ' ', '-')

Examples related to sql-server-2008

• Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object • How to Use Multiple Columns in Partition By And Ensure No Duplicate Row is Returned • SQL Server : How to test if a string has only digit characters • Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query • Get last 30 day records from today date in SQL Server • How to subtract 30 days from the current date using SQL Server • Calculate time difference in minutes in SQL Server • SQL Connection Error: System.Data.SqlClient.SqlException (0x80131904) • SQL Server Service not available in service list after installation of SQL Server Management Studio • How to delete large data of table in SQL without log?

Examples related to date

• How do I format {{$timestamp}} as MM/DD/YYYY in Postman? • iOS Swift - Get the Current Local Time and Date Timestamp • Typescript Date Type? • how to convert current date to YYYY-MM-DD format with angular 2 • SQL Server date format yyyymmdd • Date to milliseconds and back to date in Swift • Check if date is a valid one • change the date format in laravel view page • Moment js get first and last day of current month • How can I convert a date into an integer?

Examples related to select

• Warning: Use the 'defaultValue' or 'value' props on <select> instead of setting 'selected' on <option> • SQL query to check if a name begins and ends with a vowel • Angular2 *ngFor in select list, set active based on string from object • SQL: Two select statements in one query • How to get selected value of a dropdown menu in ReactJS • DATEDIFF function in Oracle • How to filter an array of objects based on values in an inner array with jq? • Select unique values with 'select' function in 'dplyr' library • how to set select element as readonly ('disabled' doesnt pass select value on server) • Trying to use INNER JOIN and GROUP BY SQL with SUM Function, Not Working

Examples related to date-format

• Format JavaScript date as yyyy-mm-dd • How to format date in angularjs • Rails formatting date • How to change date format using jQuery? • How to format Joda-Time DateTime to only mm/dd/yyyy? • Java SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss'Z'") gives timezone as IST • Display current time in 12 hour format with AM/PM • java.util.Date format conversion yyyy-mm-dd to mm-dd-yyyy • How to get a particular date format ('dd-MMM-yyyy') in SELECT query SQL Server 2008 R2 • Converting a string to a date in a cell