DEV Community

Query Filter
Query Filter

Posted on

timestamp

SELECT 
    column_name,
    column_id AS position
FROM user_tab_columns
WHERE table_name = 'YOUR_TABLE_NAME'  -- use uppercase
  AND data_type LIKE 'TIMESTAMP%'
ORDER BY column_id;

Enter fullscreen mode Exit fullscreen mode

Top comments (0)