Last name: Nightingale SDB Popularity ranking: 1104 This unusual name is of Anglo-Saxon origin, and is a nickname surname for someone with a good, sweet singing voice, from the bird, the nightingale.
You are doing everything right by using a to_date function and specifying the time. The time is there in the database. The trouble is just that when you select a column of DATE datatype from the database, the default format mask doesn't show the time.If you issue a. alter session set nls_date_format = 'dd/MON/yyyy hh24:mi:ss'.ou are doing everything right by using a to_date function and specifying the time. The time is there in the database. The trouble is just that when you select a column of DATE datatype from the database, the default format mask doesn't show the time.
You can use Sql Server Profiler for this purposes it provides a lot of useful info along the each executed query and Stored procedure as well. MSDN: SQL Profiler Data Columns. SQL Profiler displays the execution time for each event.An other straightforward way:1  DECLARE 2 datetime variables: start/end.2  SET start = GETDATE(). 3  EXEC SP_NAME.4  SET end = GETDATE().SDN: SQL Profiler Data Columns. SQL Profiler displays the execution time for each event. An other straightforward way: 1  DECLARE 2 datetime variables: start/end. 2  SET start = GETDATE(). 3  EXEC SP_NAME. 4  SET end = GETDATE().