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.
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 en 1 día
5,0 (54 comentarios)
5,8
5,8
12 freelancers están ofertando un promedio de $25 AUD por este trabajo
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!
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
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.
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.