Thursday, October 28, 2010

Select Date From DateTime In SQL

select convert(varchar,DOB,101)   from emp


101 means “mm/dd/yyyy” format

108 will return just the time “hh:mm:ss”

SELECT CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, DOB)))  from emp

SELECT CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, DOB)))  from emp

where CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, DOB)))>'10-25-2010'

No comments:

Post a Comment

Mat Table Angular

Mat Table in Angular Mat table is used to display data . its a material designed styled data-table . For using Material Table MatTableMo...