TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Deep Secrets
1.2k
543
6k
how to convert day data into week data
Feb 25 2019 7:51 AM
i have a table in my database where i am storing data on the daily basis
i am displaying that data also in day base
but now i wanat to sum the days into the weeks to display less data
example
date product-name No.items-selled
01/01 Glaxy-x 10
01/02 Glaxy-x 5
01/02 Glaxy-y 30
01/03 Glaxy-x 1
01/04 Glaxy-x 14
01/05 Glaxy-x 25
01/06 Glaxy-x 5
01/07 Glaxy-x 10
now i want to display this
insted of date display week
like
date product-name No.items-selled
(week) 1 Glaxy-x 70
1 Glaxy-y 30
please help me and give me idea how i can retrive my data from database and convert it into week
Reply
Answers (
1
)
Date is not in the Proper format while inserting n updat
Implementing Secure Authentication