In Longexposure photography you generally need wide-angle lenses or normal lenses + ND ( Neutral Density ) filters ; you need flowing objects like water,clouds or stars.In long exposure pictures you also need a tripod , you generally switch lenses focusing to infinity manually and you also need a stunning scenery or a nature piece. You can use ND filter in the day time to have the long exposure.
I took this picture two months ago in Yigitler Koyu,Izmir. It is an unique place where you can take a break and also eat some fish and listening the flowing water beside you.
Specs of the this picture : Sony a7R + Soligor 20mm f2.8 + ND Filter // 20mm ~ f10 ~ 20s ~ ISO320 ~ -0.3EV