date - current time minus mod_date_time -


i want able subtract current time mod_date_time field.

this have far:

select * prod_trkg_tran.mod_date_time - current_time user_id = '12345' * 24 * 60 "interval in minutes" 

any help?

if using oracle, can use following query:

select (mod_date_time - sysdate) * 24 * 60 prod_trkg_tran user_id = '12345'; 

Comments

Popular posts from this blog

css - I want to align grid in center -

Contact Form PHP Email Script -

python - SWIG function not printing output -