Solved

casting datetime

Posted on 1998-07-08
2
279 Views
Last Modified: 2010-03-19
How do i cast a datetime value to a string? i need to do this in an asp script.
0
Comment
Question by:csheppar
2 Comments
 
LVL 28

Accepted Solution

by:
sybe earned 50 total points
Comment Utility
If it does not go automatically, you can do it like this:

strDate = Month(dtVar) + "/"  Day(dtVar) + "/" + Year(dtVar)


0
 

Author Comment

by:csheppar
Comment Utility
that didnt do the trick but i solved it. i just had to use convert. thanks anyways.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now