Monday, December 4, 2017

ORACLE - How remove time part from datetime

Use trunc() function:
delete orders a
where
( select date_ from menu b
  where
  b.id = a.menu_id 
) <= trunc( to_date( '01.01.2017' ) )

No comments:

Post a Comment