Adobe Community
All community
This category
This board
Knowledge base
Users
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forÂ
ShowÂ
 onlyÂ
|
Search instead forÂ
Did you mean:Â
Global community
Language:
Deutsch
English
Español
Français
Português
日本語コミュニティ
Dedicated community for Japanese speakers
í•œêµ ì»¤ë®¤ë‹ˆí‹°
Dedicated community for Korean speakers
Sign In
Exit
Home
ColdFusion
Discussions
SQL Server Date mask in select statement?
Home
ColdFusion
Discussions
SQL Server Date mask in select statement?
0
Upvote
SQL Server Date mask in select statement?
rollerskatie
Participant
,
/t5/coldfusion-discussions/sql-server-date-mask-in-select-statement/td-p/107557
Sep 23, 2008
Sep 23, 2008
Copy link to clipboard
Copied
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!
TOPICS
Advanced techniques
Views
948
Translate
Translate
Report
Report
Follow
Report
More
Reply
Reply
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
1 Correct answer
rollerskatie
Participant
,
Sep 23, 2008
Sep 23, 2008
rollerskatie
•
Participant
,
Sep 23, 2008
Sep 23, 2008
I got it to work, using:
SELECT CONVERT(VARCHAR(10),dispto, 103) AS dispto
in my query.
Votes
0
Upvote
Translate
Translate
Jump to answer
3 Replies
3
Jump to latest reply
Dan_Bracuk
LEGEND
,
/t5/coldfusion-discussions/sql-server-date-mask-in-select-statement/m-p/107558#M10494
Sep 23, 2008
Sep 23, 2008
Copy link to clipboard
Copied
It depends on the db you are using.
Votes
0
Upvote
Translate
Translate
Report
Report
Follow
Report
More
Reply
Reply
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
rollerskatie
AUTHOR
Participant
,
/t5/coldfusion-discussions/sql-server-date-mask-in-select-statement/m-p/107559#M10495
Sep 23, 2008
Sep 23, 2008
Copy link to clipboard
Copied
ah yes, thought I'd mentioned that!
MS SQL Server 2005...
Votes
0
Upvote
Translate
Translate
Report
Report
Follow
Report
More
Reply
Reply
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Correct answer by
rollerskatie
AUTHOR
Participant
,
/t5/coldfusion-discussions/sql-server-date-mask-in-select-statement/m-p/107560#M10496
Sep 23, 2008
Sep 23, 2008
Copy link to clipboard
Copied
LATEST
In Response To rollerskatie
I got it to work, using:
SELECT CONVERT(VARCHAR(10),dispto, 103) AS dispto
in my query.
Votes
0
Upvote
Translate
Translate
Report
Report
Follow
Report
More
Reply
Reply
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Post Reply
Preview
Exit Preview
never-displayed
You must be signed in to add attachments
never-displayed
Â
Resources
Documentation
ColdFusion User Guide