Trunc function for SQL server??

Robert_Power_(crhadmin_-_(deleted))

Does anyone know the equivalent function to trunc for use in SQL server cos all the examples seem to use trunc...??

eLink User

Message from Xu Moua via eLinkThis is from book online for Mssql7Migrating Date Functions from Oracle to SQL ServerThe TRUNC equivalent in SQL server is CONVERT. See SQL server books onlinefor more detail.Regards,Xu MouaProduct SpecialistOpen Text CorporationSupport#: (800) 540-7292Ph: (519) 888-7111Fx: (519) 888-6663Em: xumoua@opentext.com -----Original Message-----From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf OfeLink Discussion: Livelink LiveReports DiscussionSent: Thursday, August 30, 2001 12:11 PMTo: eLink RecipientSubject: Trunc function for SQL server??Trunc function for SQL server??Posted by CRHAdmin on 08/30/2001 12:05 PMDoes anyone know the equivalent function to trunc for use in SQL server cosall the examples seem to use trunc...??[To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe