How i convert date in yyyy/mm/dd

Question

How i can Change my date into yyyy-mm-dd format and this From and to are parameters of SQL Stored Procedure .so please tell me what i do

txt_from.Text='01/08/2015';

txt_to.Text='03/08/2015';

DateTime from = new DateTime(Convert.ToInt32(txt_from.Text.Split('/')[2]), Convert.ToInt32(txt_from.Text.Split('/')[1]), Convert.ToInt32(txt_from.Text.Split('/')[0]));

DateTime to = new DateTime(Convert.ToInt32(txt_to.Text.Split('/')[0]), Convert.ToInt32(txt_to.Text.Split('/')[1]), Convert.ToInt32(txt_to.Text.Split('/')[2]));

if (to > Convert.ToDateTime(DateTime.Now.ToShortDateString()))
{
RegisterClientScriptBlock("alert", "<script>alert('To date can not be later than current date.');</script>");
}
else
{
to = to.AddDays(1);
if (from <= to)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@from",from),
new SqlParameter("@to",to),
new SqlParameter("@PortalId",Convert.ToInt32( Session["PortalId"]))

};

Mageshwaran R · Answer

Hi, Try this code: string date_format= Convert .ToDateTime(datePickStartDate.Text).ToString( "yyyy-mm-dd" )

Apurva Singh · Answer

string DateStringfrom=txt_from.Text; IFormatProvider culture = new CultureInfo("en-US", true); DateTime dateVal = DateTime.ParseExact(DateStringfrom, "yyyy-MM-dd", culture); just to dis for to date

Jaimin Shethiya · Answer

Hello Saurabh, can you convert date in SQL side and after checked. here is the example same as the your format SELECT CONVERT(varchar(10), GetDate(),111) and output will be 2019/09/24 also refer this below links for other format in future and let me know if you have needed any other help. https://stackoverflow.com/questions/889629/how-to-get-a-date-in-yyyy-mm-dd-format-from-a-tsql-datetime-field http://sqlinfo.net/sqlserver/sql_server_SELECT-Formatting_Date_Time.php Thanks

shankar naspuri · Answer

Try this String.Format("{0:yyyy\/MM\/dd}", DateTime.Now)

Abhay Shanker · Answer

Try as below string dateString = "5/06/2015"; string format = "dd/mm/yyyy"; DateTime dateTime = DateTime.ParseExact(dateString, format, CultureInfo.InvariantCulture); string strNewDate = dateTime.ToString("yyyy-dd-mm");

Rajeesh Menoth · Answer

Hi, Write like this.. //Put thiz code using System.Globalization; DateTime From = DateTime .ParseExact(txtFrom.Text, " yyyy/mm/dd " , CultureInfo .InvariantCulture); Ref this : https://rajeeshmenoth.wordpress.com/2014/11/12/string-was-not-recognized-as-a-valid-datetime/

Upendra Pratap Shahi · Answer

string DateString = "11/12/2009" ; IFormatProvider culture = new CultureInfo( "en-US" , true ); DateTime dateVal = DateTime .ParseExact(DateString, "yyyy-MM-dd" , culture);

Amitesh Verma · Answer

string DateString = "11/12/2009"; IFormatProvider culture = new CultureInfo("en-US", true); DateTime dateVal = DateTime.ParseExact(DateString, "yyyy-MM-dd", culture); refer to this 1.http://stackoverflow.com/questions/12257483/c-sharp-how-to-convert-any-date-format-to-yyyy-mm-dd 2.http://stackoverflow.com/questions/19296433/convert-datetime-in-c-sharp-to-yyyy-mm-dd-format-and-store-it-to-mysql-datetime

How i convert date in yyyy/mm/dd

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (8)