ITCanopy

Source Below query will helps you find the queries which have taken a lot of time in milliseconds. To confirm that you have query performance issues on your SQL Server instance start by examining queries by their execution time. SELECT     req.session_id     , req.total_elapsed_time AS duration_ms     , req.cpu_time AS cpu_time_ms     , req.total_elapsed_time - req.cpu_time AS wait_time     , req.logical_reads     , SUBSTRING (REPLACE (REPLACE (SUBSTRING (ST.text, (req.statement_start_offset/2) + 1,        ((CASE statement_end_offset            WHEN -1            THEN DATALENGTH(ST.text)              ELSE req.statement_end_offset          END - req.statement_start_offset)/2) + ...

  There are two ways one is that you change the date format on server level but this will cause issue like if you are getting date in business component and parsing it with some business rule and when you change the date format you need to modify operation everywhere. Below solution is simple and easy to execute. Follow below simple steps to achieve your desired date format. Open Siebel Tools. In Tool go to Applet and query the applet where you want to change the date display format. Now from list or control query the desired date field. Scroll right or use tab to find the "Display Format". Now from below you can make your own date format. For example as per my requirements I am using "DD-MMM-YYYY" after compiling the applet on UI date will display "21-Sep-2022". Format mask Description: YYYY or yyyy four digit year such as 2017 YY or yy last two digits of year such as 17 M month with no leading zero 1-12 MM Two digit month 01-12 MMM Three letter month suc...