Problem with date

[Federica T]

Is there a shorter (an easier) way to obtain a date in this format
'14/10/2004', instead of writing the following query?

select rtrim(ltrim(cast(DATEPART(m, GETDATE()) as char)))+ '/'+
rtrim(ltrim(cast(DATEPART(d, GETDATE()) as char))) + '/' +
rtrim(ltrim(cast(DATEPART(yy, GETDATE()) as char)))
as dato from dummy

Thank you!
Federica

[Simon Hayes]

"Federica T" <fedina_chicca@N_O_Spam_libero.it> wrote in message
news:ck**********@atlantis.cu.mi.it...

Is there a shorter (an easier) way to obtain a date in this format
'14/10/2004', instead of writing the following query?

select rtrim(ltrim(cast(DATEPART(m, GETDATE()) as char)))+ '/'+
rtrim(ltrim(cast(DATEPART(d, GETDATE()) as char))) + '/' +
rtrim(ltrim(cast(DATEPART(yy, GETDATE()) as char)))
as dato from dummy

Thank you!
Federica

See CONVERT() in Books Online:

select convert(char(10), getdate(), 103)

Or you can format dates in the client application - it can be easier to
provide the correct regional formatting for different clients that way. You
might not need to be able to do that in your situation, of course.

Simon

[Federica T]

> See CONVERT() in Books Online:

select convert(char(10), getdate(), 103)

Or you can format dates in the client application - it can be easier to
provide the correct regional formatting for different clients that way. You might not need to be able to do that in your situation, of course.

Simon

Thank you, Simon!