troubleshooting Question

DateTime sql2

Avatar of shilpi2
shilpi2 asked on
C#Microsoft SQL Server.NET Programming
7 Comments1 Solution618 ViewsLast Modified:
Hi Experts,

I want a datetime variable to be stored as 12:00 am in the sql2 table.
I have done the following:
                        DateTime LastCouponDate = System.Data.SqlTypes.SqlDateTime.MinValue.Value;
                       
                        String.Format("{0:t tt}", LastCouponDate);
This returns lastcoupondate as 1/1/1753 12:00:00 AM.
This gives me some error during processing. How do I get rid of 1/1/1753?

Thanks

Shilpi
ASKER CERTIFIED SOLUTION
MikeToole

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros