The accumulation of carotenoids in plants is a key nutritional quality in many horticultural crops. Although the structural genes encoding the biosynthetic enzymes are well-characterized, little is known regarding photoperiod-mediated carotenoid accumulation in the fruits of some horticultural crops. Herein, we performed physiological and transcriptomic analyses using two cucumber genotypes, SWCC8 (XIS-orange-fleshed and photoperiod-sensitive) and CC3 (white-fleshed and photoperiod-non-sensitive), established under two photoperiod conditions (8L/16D vs. 12L/12D) at four fruit developmental stages. Day-neutral treatments significantly increased fruit β-carotene content by 42.1% compared to short day (SD) treatments in SWCC8 at 40 DAP with no significant changes in CC3. Day-neutral condition elevated sugar levels of fruits compared to short-day treatments. According to GO and KEGG analyses, the predominantly expressed genes were related to photosynthesis, carotenoid biosynthesis, plant hormone signaling, circadian rhythms, and carbohydrates. Consistent with β-carotene accumulation in SWCC8, the day-neutral condition elevated the expression of key carotenoid biosynthesis genes such as PSY1, PDS, ZDS1, LYCB, and CHYB1 during later stages between 30 to 40 days of fruit development. Compared to SWCC8, CC3 showed an expression of DEGs related to carotenoid cleavage and oxidative stresses, signifying reduced β-carotene levels in CC3 cucumber. Further, a WGCNA analysis revealed co-expression between carbohydrate-related genes (pentose-phosphatase synthase, β-glucosidase, and trehalose-6-phosphatase), photoperiod-signaling genes (LHY, APRR7/5, FKF1, PIF3, COP1, GIGANTEA, and CK2) and carotenoid-biosynthetic genes, thus suggesting that a cross-talk mechanism between carbohydrates and light-related genes induces β-carotene accumulation. The results highlighted herein provide a framework for future gene functional analyses and molecular breeding towards enhanced carotenoid accumulation in edible plant organs.