What's the command for SQL to change the date-format

Question

how can I change the Date format form YYYY-MM-DD to DD-MM-YYYY ? I tried this command:

select CONVERT(varchar(10), @date, 101)

but it did not work. Can anyone help me?

Thanks!

I'm using HeidiSQL and I want to edit the format of the variable of the type "date" — Christian, Nov 19 '18 at 07:26
HeidiSql is just a managment tool, it's not a database. We need to know what database you are working with — Zohar Peled, Nov 19 '18 at 07:28
Four answers and we don’t even know what exactly the question is! — Joakim Danielson, Nov 19 '18 at 07:35

Zaynul Abadin Tuhin · Answer 1 · 2018-11-19T07:41:15.380

1

use format

declare @d date='2018-11-19';

select format(@d,'dd-MM-yyyy')

date
19-11-2018

edited Nov 19 '18 at 07:41

answered Nov 19 '18 at 07:34

score 1 · Answer 2 · edited Nov 19 '18 at 07:40

1

DECLARE @Param1 DATE
SET @Param1 = '2018-01-31'  -- YYYY-MM-DD

SELECT CONVERT(VARCHAR(10),@Param1,105) AS DesiredDate  -- DD-MM-YYYY

edited Nov 19 '18 at 07:40

Fahmi

answered Nov 19 '18 at 07:38

Jignesh patel

score 0 · Answer 3 · edited Nov 19 '18 at 08:28

0

You can try this SQL：

Select CONVERT(varchar(100), GETDATE(), 105) as 'DD-MM-YYYY'

edited Nov 19 '18 at 08:28

Fahmi

answered Nov 19 '18 at 07:32

Justin

score 0 · Answer 4 · answered Nov 19 '18 at 07:32

0

You can try below

select CONVERT (varchar(10), getdate(), 103) AS [DD/MM/YYYY]

OUTPUT:

DD/MM/YYYY
19/11/2018

answered Nov 19 '18 at 07:32

Fahmi

4 Answers4