Oracle query by time period

xiaoxiao2021-03-06  137

Oracle query by time period

Select * from [Tablename] where [create_time]> = to_date ('2004-07-01', 'YYYY-mm-dd') and [create_time] <= to_date ('2004-08-01', 'YYYY-MM -Dd ')

Pass at the 9i version. Attention time format (including bit) alignment.

转载请注明原文地址:https://www.9cbs.com/read-127247.html

New Post(0)