Separate date and time from datetime data type


Some time client demands separate Date and Time in table (GridView).
To achieve this you can use the below MSSQL Query to separate date and time from datetime datatype.

In above query field name addedon is DateTime datatype in table tbl_employee

Hi! I am Sartaj Husain. I am a Professional Software Developer, live in Delhi. I write blogs in my free time. I love to learn and share the knowledge with others because it is no good to try to stop knowledge from going forward. So free posts and tutorials. more..

No comments