Extract Time from given Date in SQL Server

Hi guys,

To extract the exact time from from given date as shown below:


Select cast(getdate() as time) [time]

How to search a word contains procedure in SQL Server...

SELECT *
  FROM sys.sql_modules m
       INNER JOIN
       sys.objects o
         ON m.object_id = o.object_id
 WHERE m.definition Like '%test%';

RAISEERROR in SQL Server......

declare @ErrorMessage varchar(1000) = error_message()

declare @ErrorSeverity int =error_severity()

declare @ErrorState int = error_state()

RAISERROR (@ErrorMessage, -- Message text.  
               @ErrorSeverity, -- Severity.  
               @ErrorState -- State.  
               );  

Previous Month First day in SQL Server

Previous Month First day...

CONVERT(DATETIME, CONVERT(VARCHAR(7), dateadd(m,-1,GETDATE()), 120) + '-01')

Extract Day, Month, Year from date

Hi guys..,

Oracle	SQL Server
SELECT to_char(sysdate,'dd') FROM DUAL;	select day(getdate())
SELECT to_char(sysdate,'mm') FROM DUAL;	select month(getdate())
SELECT to_char(sysdate,'yyyy') FROM DUAL;	select year(getdate())