How to insert date into table

You can use DATE data type instead of DATETIME! If you are using SQL Server 2008 and above!

CREATE TABLE DateTable

(

Column1 DATE

)



INSERT DateTable VALUES(GETDATE())

GO



SELECT * FROM DateTable

GO

If you are using SQL Server 2005 and below then you can use DATETIME data type and use CONVERT function while retrieve the data

CREATE TABLE DateTable

(

Column1 DATETIME

)



INSERT DateTable VALUES(GETDATE())

GO



SELECT CONVERT(VARCHAR(10),Column1, 21) FROM DateTable

GO

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Karthikreddy, if this helps please login to Mark As Answer. | Alert Moderator

Hi

Try this if you use date as datatype means you it will dispaly both date and time
if you want to display only date means then you will use
LongDate
Example: Saturday, March 28, 2013.
short Date:
Ex:3/28/2013
if you need only time means then you same as settings on the time tab

Thank You

Mark as Answer if it helps you
Thanks&Regards
Aswini Aluri

Karthikreddy, if this helps please login to Mark As Answer. | Alert Moderator

error
Column, parameter, or variable #10: Cannot find data type LongDate.

k@rth!k
karthikreddy08a50@gmail.com

Karthikreddy, if this helps please login to Mark As Answer. | Alert Moderator

hi Pandians

i am inserting date from asp page using ajax calender extender
it storing in table like 2013-03-06 format only while displaying on the web page it showing like 3/6/2013 12:00:00 AM
there i don't want time i want only date

k@rth!k
karthikreddy08a50@gmail.com

Karthikreddy, if this helps please login to Mark As Answer. | Alert Moderator

hi

try this code

DataSet ds=new DataSet ();
SqlDataAdapter sqlmd = new SqlDataAdapter("Select * from Table_2", con);
sqlmd.Fill(ds);
string StDate = "";
string STime = "";
string Speriod = "";
string test1 = ds.Tables[0].DefaultView[0][1].ToString();
StDate = test1.Split(' ')[0];
STime = test1.Split(' ')[1];
Speriod = test1.Split(' ')[2];
Response.Write(" Date : " + StDate + " Time : " + STime + " " +Speriod);

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

Karthikreddy, if this helps please login to Mark As Answer. | Alert Moderator

protected void Btn_Submit_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(contour);
DateTime startdate = Convert.ToDateTime(TextBox_startdate.Text);
string inserttour = "insert into tourprogram(startdate,fromplace,toplace)values('" + startdate + "','" + TextBox_fromplace.Text + "','" + TextBox_toplace.Text + "')";

con.Open();
SqlCommand cmd = new SqlCommand(inserttour, con);
cmd.ExecuteNonQuery();
con.Close();
showgrid();

}

sriram

Karthikreddy, if this helps please login to Mark As Answer. | Alert Moderator

use convert(varchar,'"@date", 103)

Karthikreddy, if this helps please login to Mark As Answer. | Alert Moderator

please visit the link:

http://www.tutorialsqlserver.com/Insert/Insert-in-Sql-Server.htm

Karthikreddy, if this helps please login to Mark As Answer. | Alert Moderator