SQL Server Date mask in select statement?

[rollerskatie]

Hi
I'm trying to output my query in a cfgrid, but I have a date field which I wish to mask , but I can't figure out how?!

An answer might be to mask the date in my SQL statement, can anyone tell me how?
:S

thanks!

[Dan_Bracuk]

It depends on the db you are using.

[rollerskatie]

ah yes, thought I'd mentioned that!
MS SQL Server 2005...

[rollerskatie · Accepted solution]

I got it to work, using:

SELECT CONVERT(VARCHAR(10),dispto, 103) AS dispto
in my query.