Insert Date SQL Database example
To insert date value to the table where its column defined as date. In this example we will insert both date and datatime value to the table. Let’s first create table:
As you see above we have create table four column where tast_id is primary which identity column means its value is incremental whenever new data inserted into the table and eventDate will take date, createTime column will take datetime with default value if we don’t include in insert statement, updateTime is also defined as datetime.
- Insert statement to insert the data:
- I have inserted data two time and below is results:
- For more details please go through SQL documentation here