Profile
Achievement
cahyadsn's Recent SnippetsTagged mysql
- All /
« Prev 1 Next »
You have a schedule table (period, day, subject, room) with a primary key period,day to avoid duplicate bookings. You wish to display the schedule as periods, subjects and rooms in rows, and days of the week in columns.
0
842
posted 12 years ago by cahyadsn
Given a birthdate in @dob, here are two simple formulae for age in years :
(the second formulae is for age in years to two decimal places, ignoring day of month)
0
635
posted 12 years ago by cahyadsn