Get current date

Question

Strange thing here, in a view i want to add a column with the current date, format needs to be europ.

select 
CONVERT(date ,getdate(),103) as datum

Result:

2015-01-22

I would expect it as:

22-01-2015

What's going wrong here?

Answer 1

Please try

select
CONVERT(varchar(10) ,getdate(),103) as datum

Note: datetime is not having any format, only when converting to string, it gives format

Answer 2

Refer:  CAST and CONVERT (Transact-SQL)

SELECT CONVERT(varchar(10) ,getdate(),105) as datum

---

-Vaibhav Chaudhari

Answer 3

You have data type "date" and a date don't have a specific Format; it's always the frontend which formats the date; and SSMS uses ISO Format for representing dates.

---

Olaf Helper

[ Blog] [ Xing] [ MVP]