Find Jobs
Hire Freelancers

Convert YYYY-MM to month year

$30-100 USD

Closed
Posted over 20 years ago

$30-100 USD

Paid on delivery
Hi, I am storing articles in a mySQL table. The table has a "created" field to show when the article was written. The created field is of datatype date (format YYYY-MM-DD). I want to retrieve all articles and store them under their respective created dates in month year format, i.e. January 2000 article 1 article 2 etc. February 2000 article 3 article 4 etc. I have managed to do this but only numerically, i.e. 01-2000 article 1 article 2 etc. 02-2000 article 3 article 4 etc. I want to convert the month digit to its full text equivalent, i.e. "01" to "January" and "02" to February. I came close on several occasions, I think, using date() and strtotime() etc. but ultimately, no luck. I attach a file of where I am at the moment. Please note, I'm only interested in the month and year, NOT the day. The change is purely aesthetic, e.g. it's not used in the SQL statement, but I would be interested to learn how to do it. Thanks. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site). ## Platform PHP 4.0 mySQL
Project ID: 2984836

About the project

44 proposals
Remote project
Active 21 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
44 freelancers are bidding on average $15 USD for this job
User Avatar
See private message.
$17 USD in 2 days
5.0 (148 reviews)
6.6
6.6
User Avatar
See private message.
$4.25 USD in 2 days
5.0 (110 reviews)
5.7
5.7
User Avatar
See private message.
$8.50 USD in 2 days
5.0 (29 reviews)
5.3
5.3
User Avatar
See private message.
$8.50 USD in 2 days
4.9 (68 reviews)
4.8
4.8
User Avatar
See private message.
$4.25 USD in 2 days
5.0 (27 reviews)
4.6
4.6
User Avatar
See private message.
$6.80 USD in 2 days
4.8 (61 reviews)
4.5
4.5
User Avatar
See private message.
$3.40 USD in 2 days
5.0 (17 reviews)
4.3
4.3
User Avatar
See private message.
$4.25 USD in 2 days
4.1 (43 reviews)
5.0
5.0
User Avatar
See private message.
$4.25 USD in 2 days
5.0 (20 reviews)
4.2
4.2
User Avatar
See private message.
$8.50 USD in 2 days
5.0 (12 reviews)
3.8
3.8
User Avatar
See private message.
$6.80 USD in 2 days
4.9 (24 reviews)
3.6
3.6
User Avatar
See private message.
$4.25 USD in 2 days
5.0 (25 reviews)
3.5
3.5
User Avatar
See private message.
$17 USD in 2 days
4.9 (6 reviews)
3.4
3.4
User Avatar
See private message.
$4.25 USD in 2 days
5.0 (4 reviews)
3.4
3.4
User Avatar
See private message.
$17 USD in 2 days
5.0 (11 reviews)
3.6
3.6
User Avatar
See private message.
$8.50 USD in 2 days
4.8 (8 reviews)
3.3
3.3
User Avatar
See private message.
$4.25 USD in 2 days
4.7 (26 reviews)
3.4
3.4
User Avatar
See private message.
$42.50 USD in 2 days
5.0 (12 reviews)
3.2
3.2
User Avatar
See private message.
$21.25 USD in 2 days
4.6 (11 reviews)
3.4
3.4
User Avatar
See private message.
$21.25 USD in 2 days
5.0 (3 reviews)
2.7
2.7

About the client

Flag of UNITED KINGDOM
United Kingdom
5.0
127
Member since Aug 19, 2003

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.