search

mallek-ahmed / Git-Repo

0 stars 0 forks source link

timstemps #3

Open mallek-ahmed opened 1 year ago

mallek-ahmed commented 1 year ago

WITH time_data AS ( SELECT TO_TIMESTAMP('01:03:38.603', 'HH24:MI:SS.FF3') AS deb, TO_TIMESTAMP('01:03:38.834', 'HH24:MI:SS.FF3') AS fin FROM dual ) SELECT (EXTRACT(DAY FROM (fin - deb)) 86400000) + (EXTRACT(HOUR FROM (fin - deb)) 3600000) + (EXTRACT(MINUTE FROM (fin - deb)) 60000) + (EXTRACT(SECOND FROM (fin - deb)) 1000) AS difference_ms FROM time_data;

mallek-ahmed commented 1 year ago

SELECT CASE WHEN REGEXP_LIKE(your_variable, '^\d{2}:\d{2}:\d{2}.\d{3}$') THEN 'Valid' ELSE 'Invalid' END AS result FROM your_table;