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