DATETIME column : Datetime « Date Timezone « SQL Server / T-SQL






DATETIME column

 



3> CREATE TABLE works_on (emp_no INTEGER NOT NULL,
4>                   project_no CHAR(4) NOT NULL,
5>                   job CHAR (15) NULL,
6>                   enter_date DATETIME NULL)
7> GO
1>
2> drop table works_on;
3> GO

 








Related examples in the same category

1.Converted to a datetime
2.Get Day only from a datetime variable