date format in asp.net

Question

in my database i stored date in the format "yyyy-mm-dd" i need to compare the stored dates with the current date. But How can i get the current date in the above format in asp.net.

Welcome to StackOverflow! Can you provide a few more details in regards to your question. Where do you want to compared these dates? Server-side or client side? What's the use of the comparison? — Alastair Pitts
– Alastair Pitts, Commented Oct 6, 2010 at 4:57

RPM1984 · Accepted Answer · 2010-10-06 04:57:24Z

4

string dt = DateTime.Now.ToString("yyyy-MM-dd")

answered Oct 6, 2010 at 4:57

RPM1984

73.3k62 gold badges241 silver badges364 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Brian Hinchey · Accepted Answer · 2010-10-06 05:09:05Z

1

You should consider converting that date field in your database schema to a "datetime" data type. That will make it easier to do operations with this value (e.g. equality, greater than, less than, addition, subtraction etc...).

edited Oct 6, 2010 at 5:09

answered Oct 6, 2010 at 5:02

Brian Hinchey

3,6911 gold badge42 silver badges36 bronze badges

Comments

Ben · Accepted Answer · 2010-10-06 05:15:14Z

1

if (DateTime.Today.ToString("yyyy-MM-dd").Equals(myDateString))
{
    //Do my thing here
}

answered Oct 6, 2010 at 5:15

Ben

113 bronze badges

Collectives™ on Stack Overflow

date format in asp.net

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related