Tag «TRUNC»

SQL Server: Truncating Dates

TRUNC is a function I used a lot when I worked with Oracle and helped me slicing my data in several different ways, and keeping the columns in date format. That function is not available in SQL Server unless you work it around by using CONVERT or DATEPART. But both change the content to VARCHAR. …