I am having problems when formatting a date in SQLSERVER, my query is
SELECT CONVERT(VARCHAR(10), FECHA_INI_FALLA, 13) AS FechaFalla
and the result I get is
12 SEP 2017
and what I want to get is
12/SEP/2017 O 12-SEP-2017
It should be noted that I do not want to show the time, minutes and seconds
What should I change to get that format?
From SQL Server 2000 :
SELECT REPLACE(CONVERT(VARCHAR(11), GETDATE(), 13), ' ', '/')
Starting with SQL Server 2012 :
SELECT FORMAT( GETDATE(), 'dd/MMM/yyyy', 'en-US' )
You'll get:
12 / Sep / 2017
For your case:
SELECT FORMAT(FECHA_INI_FALLA, 'dd/MMM/yyyy', 'en-US' )
Reference:
Use:
Modification according to the edition of the OP question about not showing time on the date:
SELECT replace(CONVERT(nvarchar, Convert(Date, FECHA_INI_FALLA), 13), ' ', '/')
or
SELECT replace(CONVERT(nvarchar, Convert(Date, FECHA_INI_FALLA), 13), ' ', '-')
Thanks to Davilo for the suggestion of limitation of information using varchar which does not perform a double cast:
SELECT replace(CONVERT(VARCHAR(11), GETDATE(), 13), ' ', '/')
SELECT replace(CONVERT(VARCHAR(11), GETDATE(), 13), ' ', '-')
Greetings
Use Convert , with format 106, that already omits information of hours, minutes, etc.
Then, replace the spaces with '-' or '/' , as you prefer:
select replace(convert(varchar, FECHA_INI_FALLA, 106), ' ', '-')
It will give you the desired result.
You should use:
SELECT CONVERT(VARCHAR(10), FECHA_INI_FALLA, 103) AS FechaFalla
Since the 103 parameter is the British / French format: dd / mm / yyyy
For more details, see: link
Greetings!