Convert SQL Server Date Format

sql date format yyyymmdd
sql convert string to date dd/mm/yyyy
sql cast date
convert(datetime to date sql)
sql date format dd-mmm-yyyy
sql time format hh:mm
convert timestamp to date sql
sql insert date format yyyy-mm-dd

I'm using this query:

select convert(nvarchar(MAX), getdate(), 100);

It's returning

Aug 16 2018  3:45PM

I'm trying to get this date format instead:

16 AUG 15:45

Please help me achieve it. Thanks

Try this: with format function

SELECT upper(FORMAT( getdate(), 'dd MMM HH:mm', 'en-US')) 

Date and Time Conversions Using SQL Server, How to get different SQL Server date formats. Use the date format option along with CONVERT function; To get YYYY-MM-DD use SELECT  --Using Different Conversion functions for SQL Server Date Format SELECT PARSE('Wednesday, June 14, 2017' AS DATETIME USING 'en-US') AS 'Result 4'; SELECT TRY_PARSE('Wednesday, June 14, 2017' AS DATETIME USING 'en-US') AS 'Result 5'; SELECT CONVERT(DATETIME2, SYSDATETIME()) AS 'Result 6'; SELECT TRY_CONVERT(DATETIME2, '6/14/2017 11:57:53 AM') AS 'Result 7';

This gets you what you want, and without using the awfully slow FORMAT function:

SELECT D, CONVERT(varchar(6),DATEADD(HOUR, -1, D),13) + ' ' + CONVERT(varchar(5),CONVERT(time(0),DATEADD(HOUR, -1, D)),14)
FROM (VALUES(CONVERT(datetime2(0),'2018-08-16T15:45:00'))) V(d);

Edit: Seems the OP moved the goals posts again (initially they wanted the time changed from 01:38 AM to 13:38, and then 03:45 PM to 14:45), and as a result DATEADD isn't required. I haven't bothered removing this though, as it was correct at the time; and I don't trust the goal posts won't move again.

CAST and CONVERT (Transact-SQL), All other conversion styles return error 9809. Note. SQL Server supports the date format, in Arabic style, with the Kuwaiti algorithm. The length of the resulting data type (for char, varchar, nchar, nvarchar, binary and varbinary) expression. Required. The value to convert to another data type. style. Optional. The format used to convert between data types, such as a date or string format.

Try this

upper case 'Aug' to 'AUG'

SELECT UPPER( FORMAT( GETUTCDATE(), 'dd MMM HH:mm', 'en-US' ) )

SQL Convert Date functions and formats, sytle specifies the format of the date. The value of style is a number predefined by SQL Server. The style parameter is optional. The following table illustrates the  Data Types for Date and Time. We have the following SQL convert date and Time data types in SQL Server. In SQL Server, we have used built-in functions such as SQL GETDATE() and GetUTCDate() to provide server date and format in various formats. Execute the following queries to get output in respective formats.

use upper and 'dd MMM HH:mm', 'en-US' format

SELECT Upper( FORMAT( getdate(), 'dd MMM HH:mm', 'en-US' ))

it reutrns 16 AUG 11:03

Convert Datetime to String in a Specified Format in SQL Server, Converting a string in ANSI/ISO and US date format to a datetime. Both CONVERT() and TRY_CONVERT() function can recognize ANSI/ISO and US formats with  sytle specifies the format of the date. The value of style is a number predefined by SQL Server. The style parameter is optional. The following table illustrates the valid style and the corresponding format of the datetime after converting to a string. Without century (yy) With century (yyyy) Default for datetime and smalldatetime.

Try this

Query:

select UPPER(FOrmat(GETDATE(),'dd MMM HH:mm'))

Result: 16 AUG 17:04

Convert String to Datetime in SQL Server, SQL Server (2005, 2000, 7.0) does not have any flexible, or even non-flexible, way of taking an arbitrarily structured datetime in string format  In SQL Server, you can use the T-SQL FORMAT() function to format the date and/or time. Simply provide two arguments; the date/time and the format to use. The

Sql Server string to date conversion, SQL Server string to date / datetime conversion - datetime string format sql server​. -- MSSQL string to datetime conversion - convert char to date - convert varchar  But this method somewhat ambiguous and it would be difficult for you to remember the number with respect to Specific Date Format. That's why in next versions of SQL server there is better option. If you are using SQL Server 2012 or above versions, you should use Format() function FORMAT ( value, format [, culture ] )

SQL Datetime Conversion - String Date Convert Formats, In MS SQL Server, you can use the CONVERT() function to converts an expression from one data type to another data type. When it comes to  SQL Server 2008 Date Format One of the most frequently asked questions in SQL Server forums is how to format a datetime value or column into a specific date format. Here's a summary of the different date formats that come standard in SQL Server as part of the CONVERT function.

SQL Server Date Format Cheatsheet, In SQL Server, you can use the CAST() function to convert an expression of one data type to another. This function works almost the same as  SQL Server Date Formats One of the most frequently asked questions in SQL Server forums is how to format a datetime value or column into a specific date format. Here's a summary of the different date formats that come standard in SQL Server as part of the CONVERT function.

Comments
  • you don't want year ?
  • Why does 01:38 AM become 13:38? AM is morning, not afternoon.
  • @AmitKumar yes, not year.
  • Different values now since I last commented, why does 3:45 PM become 14:45? Is it always an hour before?
  • @Larnu please check latest edit.
  • how can i change Aug as AUG ?
  • Look at the UPPER() function.
  • try this : upper(FORMAT( getdate(), 'dd MMM HH:mm', 'en-US' ) )
  • can i get without using upper() ?
  • as far my knowledge using format function only , not possible, you've to use upper.
  • @JoakimDanielson yes thank you i have added could you please change now your down vote
  • can i get without using upper() ?