delete orders a
where
( select date_ from menu b
where
b.id = a.menu_id
) <= trunc( to_date( '01.01.2017' ) )
Showing posts with label oracle - trunc(). Show all posts
Showing posts with label oracle - trunc(). Show all posts
Monday, December 4, 2017
ORACLE - How remove time part from datetime
Use trunc() function:
Subscribe to:
Posts (Atom)