Brief description  about Online courses   join in Online courses
View Sakshi  Soni 's Profile

Inserting Date in the Table

When you are inserting date in the table then the column date of the table is a variable character or integer? For example-
Create Table si_emp(Name varchar(20),salary int,joindate varchar(20));

Over here should the joining date be followed by varchar(20) or int?

Asked by Sakshi Soni | Jun 27, 2013 |  Reply now
Replies (2)
View ashish a upadhyay 's Profile
Joindate datetime, no braces required
Nov 26, 2014
View sql trainer 's Profile
You Should use 'Date' data type and Format: YYYY-MM-DD.

Jul 4, 2013