Find Jobs
Hire Freelancers

Create a MySQL Countdown String

$10-30 AUD

Completed
Posted almost 9 years ago

$10-30 AUD

Paid on delivery
I have a column in my database table of the unix timestamp that a sports event starts. The column is named start_unix. I want a sql query that will return a countdown, the time until this event starts. It should return the following: xx days xx hours - if the event starts in more than 24 hours xx hours - if the event starts in more than 1 hour xx minutes - if the event starts in less than 60 minutes xx seconds - if the event starts in less than 60 seconds For each of the above it should have correct grammar and use proper plurals, i.e. it should say 1 day 2 hours and not 1 days 2 hours. If the column's value is NULL, it will return NULL. The solution only needs to be a SQL query, I do not need any javascript or dynamic updates.
Project ID: 7773375

About the project

12 proposals
Remote project
Active 9 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
Awarded to:
User Avatar
hi, I am interested to write a select query to get countdown value from mysql table. Please check my previous work in my profile and let me start with the job. Thanks Prakash
$30 AUD in 1 day
5.0 (54 reviews)
5.8
5.8
12 freelancers are bidding on average $25 AUD for this job
User Avatar
I have 3 years experience in mysql programming I can provide you the solution quickly inbox me for more details...
$15 AUD in 1 day
5.0 (77 reviews)
5.5
5.5
User Avatar
Dear, I am new in freelencer but I have 2 years experience in PHP,MYSQL ,If you hire me i will give excellent work and quality services for you and your requirements. Have a nice day!
$30 AUD in 1 day
5.0 (26 reviews)
4.7
4.7
User Avatar
Hello, i have more than 8 year experience in php,html,mysql and i can help you for sure we will talk more when we meet together Thanks Ricky
$25 AUD in 1 day
4.8 (11 reviews)
4.5
4.5
User Avatar
Hi, I can carry out your task I have done creation and customization of many PHP/Mysql based websites . I have 3 yrs of experience in this PHP/Mysql/Wordpress development field. recently i developed custom wordpress Plugin and custom Template for a client at Freelancer.com. Invite me to done this task
$25 AUD in 1 day
4.9 (16 reviews)
4.2
4.2
User Avatar
Dear employer, I've very good experience with MySQL. I can give you a MySQL query that satisfies the specified requirement. I'm ready to start working on the project. Looking forward to working with you. Awaiting a positive reply from you. Thanking you Shaik Allabakash.
$15 AUD in 0 day
4.6 (4 reviews)
3.5
3.5
User Avatar
A proposal has not yet been provided
$32 AUD in 1 day
4.8 (1 review)
1.6
1.6
User Avatar
Hello If you want, I will provide you the solution within 3-4 hours. I have sql query with me, but once you say yes, I will test it before delivering it to you.
$30 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there, I would like to work on this. I have made similar MySql, Oracle, SM-Sql queries in past. Please come over chat to discuss further.
$30 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have the skills and experience needed to make your project. Check my perfir for more details. I wait for your contact.
$15 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Canberra, Australia
4.8
7
Payment method verified
Member since Feb 20, 2014

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.