Ask a Question related to Coldfusion Database Access, Design and Development.
-
dpinder123 #1
SQL Server DateTime Data Type
When inserting a date into my SQL Server DB, I'm using the datetime Data Type.
It displays the date in the format I want, but, it also displays the time. How
do I get it to only display the date?
Thanks.
dpinder123 Guest
-
Converting data type varchar to data type money
Hi all, Tearing my hair out trying to figure this out. If anyone can provide any help i would greatly appreciate it. When I try to do an insert... -
HowTo Send Uploaded File with INPUT Type file to Sql Server Image Data Type
I have the following problem: I have the following form client side: <FORM.......> <FORM action="./WZUpload.asp" method="Post"... -
HowTo Send Uploaded File with INPUT Type file to Sql Server Image Data Type ?
I have the following problem: I have the following form client side: <FORM.......> <FORM action="./WZUpload.asp" method="Post"... -
cast from datetime type to smalldatetime type?
Hi, How can I cast from datetime type to smalldatetime type. I get the records from a table which has got a datetime type column but I want to... -
Question about 'image' data type in SQL Server
Brandon, I think that the following document in the .NET framework documentation will help. It is titled "Conserving Resources When Writing BLOB... -
mxstu #2 Re: SQL Server DateTime Data Type
When outputting data, you can use the DateFormat function to display the date
in the style you want.
<!--- not tested --->
<cfoutput query="yourQuery">#DateFormat(yourDateColumn,
"mm/dd/yyyy")#</cfoutput>
mxstu Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
