oracle中date類型怎么轉換和比較大小?
使用 to_date('2012-04-26','YYYY-MM-DD')例如:select created from user_objects where created > to_date('2012-04-26','YYYY-MM-DD');CREATED---------10-MAY-1210-MAY-1205-JUN-1205-JUN-1205-JUN-12
oracle中date類型怎么轉換和比較大小?
使用 to_date('2012-04-26','YYYY-MM-DD')例如:select created from user_objects where created > to_date('2012-04-26','YYYY-MM-DD');CREATED---------10-MAY-1210-MAY-1205-JUN-1205-JUN-1205-JUN-12