![]() ![]() I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. Oracle SQL Tutorials For Beginners – Learn Oracle SQL from scratch with Oracle SQL Online Course Oracle TO_DATE | Convert Datetime to Dateĭo you want to learn Oracle SQL for Beginners, then read the following articles. You should read the following post to learn more details about TO_DATE function. Oracle can implicitly convert ’24-JUL-21′ to a DATE value using the default date format ‘DD-MON-YY’ as follows. Where to_char(begin_interval_time,'DD-MON-YYYY')='1'Īnd EXTRACT(HOUR FROM begin_interval_time) between 8 and 10 Select snap_id,begin_interval_time,end_interval_time Owner||'.'||object_name||':'||nvl(subobject_name,'-') obj_name,s.program,s.module,s.machineįrom dba_hist_active_sess_history s, dba_objects o (select sample_time,s.sql_id sql_id, session_state, blocking_session, I will query the dba_hist_active_sess_history according to sample_time between ’ 07:30:00′ and ’ 15:10:02′ as follows.įor example select v.sql_text,v.sql_fulltext,sub.* from v$sql v, Where date_column to_date('','YYYY-MM-DD') where to_char(begin_interval_time,'DD-MON-YYYY')='1' EXTRACT(HOUR FROM begin_interval_time) between 8 and 10 If you will compare any column with a DATE format, related column and data should be DATE datatype, namely SQL date comparison should be between DATE to DATE format as follows. ![]() SQL Date comparison is most used statement for DBA or developers. I will explain Oracle SQL Date Comparison in this post.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |