when I execute my stored procedure in my SQL editor it returns me correct data but when I call it from cfstoredproc

cfstoredproc( procedure="getAllProduct",datasource="#environment.getEnv('DB_DATASOURCE')#" ) {
			cfprocparam( cfsqltype="cf_sql_varchar", value=arguments.userId );
			cfprocresult( name="local.products", resultset=1 );
		};
		writeDump(local.products);

it returns the remaining time as an epoch value

i would say that since the sp is only returning the time component into a timestamp, the convert to epoch date seems appropriate, if you do timeformat() on your output instead of looking at the dump, it will show as you expect.

@Matt Jones thanks but I found the mistake that i made in my sp and I solved it 😓