query with top and order by - convert from MsSql to Oracle

Question

I need to convert this query from MsSql syntax to Oracle syntax:

select top 1 (convert(varchar, UPDATED_DATE, 23)) as date from DA_CATEGORY order by date desc

How do I do this? I need the data from both DB types to be the same string / value.

Put `FETCH FIRST 1 ROW ONLY` after the ORDER BY clause. – jarlh Jan 07 '21 at 14:15 — jarlh, Jan 07 '21 at 14:15

score 2 · Accepted Answer · answered Jan 07 '21 at 14:15

2

You can use the fetch clause as follows:

select to_char(UPDATED_DATE,'YYYY-MM-DD') as date 
from DA_CATEGORY 
order by UPDATED_DATE desc
fetch first row only

answered Jan 07 '21 at 14:15

Popeye

1 Answers1