Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts

Monday, July 14, 2014

Free Microsoft E-Books available for Download


Microsoft has released a bunch of free e-books for Free. Why would someone interested in the topic not tempted to download the e-books when its exclusively free.

Download faster. Microsoft will close the free download as it reaches 2 Million downloads. So Hurry up.

http://blogs.msdn.com/b/mssmallbiz/archive/2014/07/07/largest-collection-of-free-microsoft-ebooks-ever-including-windows-8-1-windows-8-windows-7-office-2013-office-365-office-2010-sharepoint-2013-dynamics-crm-powershell-exchange-server-lync-2013-system-center-azure-cloud-sql.aspx

Friday, July 4, 2008

First day of the month oracle SQL Query

pretty much simple way get the First day of any month using SQL Query is

select trunc(sysdate,'MONTH') from dual

Trunc Function of PL/SQL when passed with a 'Month' parameter will return the first date of a month.

instead of sysdate use the date value you want

sysdate trunc(my_birth_day,'MONTH') from My_Details