date usage in SQL query [message #677498] |
Mon, 23 September 2019 17:31 |
|
James1116
Messages: 4 Registered: September 2019
|
Junior Member |
|
|
HI,
can anyone tell me why following query not return any result?
select * from XXYH.XXYH_MTL_ITEMS_INTF_STG where creation_date between to_date('20-sep-2019 00:00:00', 'dd-mon-yyyy hh24:mi:ss')
and to_date('24-sep-2002 23:59:59', 'dd-mon-yyyy hh24:mi:ss')
my creation_date format is like '23-SEP-10'
Thanks
James
|
|
|
|
|
|
|
|
Re: date usage in SQL query [message #677601 is a reply to message #677520] |
Mon, 30 September 2019 05:46 |
Bill B
Messages: 1971 Registered: December 2004
|
Senior Member |
|
|
SELECT A.Item_description, A.Creation_date
FROM Xxyh.Xxyh_mtl_items_intf_stg A,
( SELECT Item_description
FROM Xxyh.Xxyh_mtl_items_intf_stg
GROUP BY Item_description
HAVING COUNT (Item_description) > 1) B
WHERE A.Item_description = B.Item_description
ORDER BY A.Item_description, A.Creation_date
|
|
|