By discovering the Microsoft BI Tools and implementing BI platform, I'm improving my technical and design BI knowledge. Sometime, I took a lot of time to find what I searched. On a real project, Time is money. That's the reason why I would like to share these knowledge with you.
Wednesday, September 2, 2009
Get the date without the time
PL/SQL SELECT TRUNC(SYSDATE) --That should get you today's date
T-SQL SELECT DATEADD(d,DATEDIFF(d,0,GETDATE()),0) --That should get you today's date
No comments:
Post a Comment