AspdotnetCodes.com
Search
Articles
Books
Resources
Asp.Net News
Downloads
Free Tech Magazines
Asp.Net Web Hosting
Archives
Softwares
Newsletter
Suggest Us
Link to Us
Feeds Subscription
Articles
Questions & Answers
Tips & Tricks
 Date Format Issues
Posted by Ravi Kumar on  1/8/2009 3:26:54 AM Category: ADO.NET
Add to my favorites
Email to friend
I am working on ERP application Using SQL Server and asp.net2.0 . I have problem with date format. i.e If the client system date format is DD/mm/YYYY or mm/DD/YYYY. how to hadle this format and send it to sqlserver so that data can be inserted with out error.

Please provide me the solution.

Post Your Reply Post New Question

 Viewer's Reply
Date Format Issues
Answered By Kunwar on 3/4/2009 5:01:11 AM
There are two ways to it.

Either you allow your user to enter Date in fixed format
i.e. MM/DD/yyyy
or you save the Date in UTC Format.

From Kunwar
http://KpratapS.blogspot.com
 
Get Your Answer.................................!
Answered By RAJESH KUMAR VISHWAKARMA on 9/26/2009 6:09:05 AM
Try To use Date Picker!

or send me syntax of Table.

or to use varchar datatype.

Everything is Possible!
 
Post Your Reply If you still have problem, post it again under this reply for better response.

 
Sponsored by
Building a Web Application Security Program
When Good HTML Goes Bad: How You Can Protect Your Web Applications
Web Application Security — How to Minimize Prevalent Risk of Attacks