how to split date n tim from datetime in sql table using C#

Question

i want to spilt datetime into date and time in their separate column at the time of insert record. so need guide for this thanks...

Jignesh Kumar · Answer

Hi Akhter, While saving you are passing parameter that place you have to pass in date convert ( date , Entrydate ) and Time paremeter. convert ( varchar (8), convert ( time , Entrydate )

Akhter HUssain · Answer

Dear Jignesh i am using this query SELECT CONVERT(VARCHAR(7), Entrydate, 108) AS Time, CONVERT(VARCHAR(7), Entrydate, 105) AS Date FROM Country but how will i save data in database using c# of date and time

Akhter HUssain · Answer

protected void Button2_Click(object sender, EventArgs e) { DateTime date1 = Convert.ToDateTime(TBIN.Text); DateTime date2 = Convert.ToDateTime(TBOut.Text); DateTime d1 = Convert.ToDateTime(TBIN.Text); DateTime d2 = Convert.ToDateTime(TBOut.Text); TimeSpan span = d2 - d1; TBHrs.Text = span.TotalHours.ToString(); ///////// Round Hours /////// TBHrs.Text = Math.Round(double.Parse(TBHrs.Text), 0).ToString(); int t3; int t4; // int t5; t3 = int.Parse(TBHrs.Text); t4 = int.Parse(TBSDH.Text); // t5 = int.Parse(TBOT.Text).ToString(); if (t3 > t4) { TBOT.Text = (t3 - t4).ToString(); } if (TBHrs.Text == "8") { TBDay.Text = "1"; } else if (t3 > 8) { TBDay.Text = "1"; } else if (t3 > 7) { TBDay.Text = "1"; } else if (t3 { TBDay.Text = ".5"; } SqlDataSource1.InsertCommand = " insert into HR3 (DateTime,OutDT,Day,Days,code,OT) values ('" + date1 + "','" + date2 + "','" + TBHrs.Text + "','" + TBDay.Text + "','" + TBEID.Text + "','" + TBOT.Text + "')"; SqlDataSource1.Insert(); }

Akhter HUssain · Answer

no i am not defining parameter at the time of saving of Time and Date ,just pasing parameter of Entrydate which data type is datetime

Sreekanth Reddy · Answer

Hi Akhter, Hi, In database you can follow as like below : 1)If your coulumn types are date & another column time follow like below Here my variables @dtIs is Date type. And my @tmIs is time type. declare @dtIs date; set @dtIs = convert(date, getdate()) declare @tmIs time; set @tmIs = convert(time, getdate())) 2)If your columns are in varchar type, Then again convert the @dtIs & @tmIs to varchar type as like below : select convert(varchar(max),@dtIs) select convert(varchar(max),@tmIs) Hope you understood. If it helps, mark as answer. Thanks.

Jignesh Kumar · Answer

Hi Akhter, Please find below query for split data and time into Two Coulmn. select convert ( date , getdate()) as [ Date ], convert ( varchar (8), convert ( time , getdate())) as [ Time ] You can refer below link. https://dba.stackexchange.com/questions/206014/split-date-and-time-in-sql-query

Akhter HUssain · Answer

Sreekanth Reddy is it not possible to spilt Time from Datetime ,because i am passing datetime format into database from front

Sreekanth Reddy · Answer

Hi Akhter, For your scenario, we can use "Date" type for one column & "Time" type for another column. Dont use "DateTime". And to the respective columns from our front end get the date and split as like below : DateTime dt = new DateTime.Now; string time = dt.ToString("hh:mm tt"); string date = dt.ToString("yyyy-MM-dd"); Now you can pass time & date to your database. Mark as answer, If it helps. Thank you.