Skip to main content
R
rollerskatie
Inspiring
September 23, 2008
Answered

SQL Server Date mask in select statement?

  • September 23, 2008
  • 2 replies
  • 1077 views
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!
This topic has been closed for replies.
Correct answer rollerskatie
I got it to work, using:

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

2 replies

R
rollerskatieAuthor
Inspiring
September 23, 2008
ah yes, thought I'd mentioned that!
MS SQL Server 2005...
R
rollerskatieAuthorCorrect answer
Inspiring
September 23, 2008
I got it to work, using:

SELECT CONVERT(VARCHAR(10),dispto, 103) AS dispto
in my query.
D
Dan_Bracuk
Inspiring
September 23, 2008
It depends on the db you are using.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices