Closed

query with date equal to NOW()

39 freelancers are bidding on average €20 for this job

TakeReal

Hello, My name is Sergey. I am Freelancer from [url removed, login to view], Russia. I can help you as SQL expert to select records where date is equal to NOW(). Yes, I understand: format is 13/07/2017 Relevant Skills and Experienc More

€30 EUR in 1 day
(1618 Reviews)
7.9
uhjk

Hello do you have 13/07/2017 or 2017-07-13 etc? I mean database column is varchar or date? Query would change accordingly. It's better to make query using php date function maybe. Relevant Skills and Experience I am g More

€23 EUR in 1 day
(614 Reviews)
8.0
€25 EUR in 0 days
(168 Reviews)
6.9
phpfreelancer86

Hello Sir, I've reviewed your requirement and I'm ready to work with you.I have almost 8+ years of experience in web development. I will provide quality work as well full support for any query. Relevant Skills and Ex More

€24 EUR in 0 days
(152 Reviews)
6.2
celalaybar

Hello. You can use SELECT STR_TO_DATE("13/07/2017", "%d/%m/%Y") to convert date to MySQL date format. Relevant Skills and Experience I am competent in MySQL and PHP. Proposed Milestones €14 EUR - Done.

€14 EUR in 0 days
(91 Reviews)
5.8
Europa17

Hi sir Nice to meet you. I can help you with your work. Please contact me for discussing more details. Relevant Skills and Experience My sql, Laravel, Angular js, Node js, html,css,javascript and Jquery. If you are lo More

€29 EUR in 1 day
(27 Reviews)
5.6
zu02

Hi, I will show you- via Ms Access Relevant Skills and Experience I'm programming in Access/SQL/VB since 1997 Proposed Milestones €29 EUR - default

€29 EUR in 1 day
(17 Reviews)
5.4
MoustafaS

Hello, I am available now to help with this. Relevant Skills and Experience Done same before Proposed Milestones €30 EUR - After

€30 EUR in 1 day
(11 Reviews)
4.3
acshovon

Hi, Your requirement seems very easy. If you are using My SQL as database then addition of a simple 'WHERE' in query will solve your requirement. Just need to apply properly. Please feel free to join me on chat to dis More

€19 EUR in 1 day
(15 Reviews)
4.0
informavenue

Hi, I can do it. I'm ready to start working right now. My experience on web-dev more then 7 years! __☆_________*_________☆_ ______☆____*o*____☆_____ _☆________*o*o*_______☆_ _____☆___*o*o*o*___☆____ Relevant Skills an More

€22 EUR in 0 days
(17 Reviews)
4.2
gagandeeps416

Hello, Its an easy task for me. We need to customize the db date pattern and now date pattern to match with each other. Please contact me i will provide you the query. Thanks Relevant Skills and Experience php,mysql More

€24 EUR in 1 day
(12 Reviews)
4.0
olevea21

Hello,Hope you doing well.I read your project description,Lets have a technical discussion,negotiate costing, timeline and then we proceed further. I Will show my past work also. Thanks! Relevant Skills and Experienc More

€25 EUR in 1 day
(5 Reviews)
3.8
isyncevolution

Example => SELECT STR_TO_DATE('13/07/2017', '%d.%m.%y') as d1 , CURDATE() as d2 having d1 = d2 Solution in few minutes GUARANTEE 12 Yrs. Exp. in Web Software Development. Relevant Skills and Experience PHP MySql Pr More

€20 EUR in 1 day
(16 Reviews)
3.9
Precious01

Hi, to do what you need, you need to use the curdate() method and format it with date_format() so that you can easily compare with the current format you have in your database. I can assist with this. Relevant Skills More

€13 EUR in 0 days
(11 Reviews)
3.3
nexcodinfotech

Hello sir, As it looks simple query for us because we have done lots of work with dates and calendar functions. So PM me once will discucss it in better way. Relevant Skills and Experience PHP, MySQL, API, ANdroid, JA More

€14 EUR in 1 day
(4 Reviews)
3.3
blister47

Hello, Please find my proposed solution below: select date_col from tbl_demo where DATE_FORMAT(STR_TO_DATE(date_col,'%d/%m/%Y'), '%Y-%m-%d %H:%i:%s') < NOW(); Thanks. Relevant Skills and Experience MySQL PHP Propo More

€8 EUR in 1 day
(4 Reviews)
2.8
zallim

yes i can do it.i am professional having experienced team of developers. don't worry about the quality of work. lets get started? Relevant Skills and Experience more than 2 years of experience in web development and d More

€23 EUR in 1 day
(3 Reviews)
1.8
ukgolang

Hi, I can help you with your MySQL query. I have 15 years experience working with MySQL. Stay tuned, I'm still working on this proposal.

€14 EUR in 1 day
(2 Reviews)
1.9
Devlope

A proposal has not yet been provided

€19 EUR in 1 day
(3 Reviews)
1.2
joaopaulomouram

I can help you now and finish it in 1 minute. Relevant Skills and Experience mysql Proposed Milestones €12 EUR - Done this task

€12 EUR in 0 days
(1 Review)
0.8