Fermé

Fix mysql query help

Hi!

I have a DB field type datetime in which there are some dates, like:

2015-09-17 14:09:48

I now want to change all the dates to the following one:

2015-09-16 00:00:00

But simply dont know how the update query looks like.

Table is imagefound, column is first_found

Anybody who can help?

Compétences : MySQL, PHP, Architecture Logicielle

Voir plus : loop mysql table update, ajax div refresh mysql table update, mysql fix 2013 query, mysql table update script, mysql execute script file table update, update query mysql, mysql table update, update query mysql aspnet, csv mysql table update, create update query mysql

Concernant l'employeur :
( 106 commentaires ) Lüneburg, Germany

N° du projet : #8493229

58 freelance ont fait une offre moyenne de 16 $ pour ce travail

rajeshsonisl

Hello! With 98% to 99% completion rate, 850+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page [url removed, login to view] Plus

34 $ USD en 1 jour
(827 Commentaires)
8.3
csajit

HELLO THERE, Over 200+ Positive Reviews. Over 90% Completion Rate. 5 Star Rating. 8+ Years of experience in PHP/MYSQL I AM INTERESTED IN WORKING ON THIS PROJECT. PLEASE CHECK MY REVIEWS AND THEN DECIDE ON Plus

30 $ USD en 1 jour
(262 Commentaires)
6.7
AndrewYer

Предложение еще не подано

10 $ USD en 0 jours
(186 Commentaires)
6.4
danale72

-- set DATE type for colunm which store date but not time ALTER TABLE imagefound CHANGE COLUMN first_found first_found DATE

10 $ USD en 1 jour
(81 Commentaires)
5.8
mrbacklink

A proposal has not yet been provided

15 $ USD en 0 jours
(80 Commentaires)
5.8
GenieCode

I can do this dateTime Update for u in no time. Pay only if u r satisfied with my work. I am expert in SQL, MySQL, PHP. I can do this job for u in a little time. I will be available to u any time. I will help u unti Plus

10 $ USD en 0 jours
(20 Commentaires)
5.0
vinaysinghh

A proposal has not yet been provided

15 $ USD en 1 jour
(35 Commentaires)
5.1
sudiptablg

I have 5+ years experience in PHP, Wordpress, Joomla,CSS, JQuery, HTML etc. I also developed many software applications for banking, accounting, code generator, printing bills etc. I have ability to modify any plugg Plus

15 $ USD en 1 jour
(17 Commentaires)
4.7
baguswah

Hi, I would be happy to create the sql script for you to update the date as your request

15 $ USD en 1 jour
(24 Commentaires)
4.5
Webbleu

Greetings, We have gone through your requirement and would to take this opportunity to work on this project. Can you send a detailed requirement about your project. Please check few work done by us: Feel Plus

24 $ USD en 1 jour
(27 Commentaires)
4.6
jperusan

Use following query: UPDATE imagefound SET first_found = '2015-09-16 00:00:00'; And that's that. So simple. Greetings.

10 $ USD en 1 jour
(28 Commentaires)
4.7
softtechsurat

Hello sir/madam, we have read and understand your requirement and very much confident that we can complete this project within low budget and less time . Give us chance to serve you better Looking forward to be Plus

24 $ USD en 1 jour
(33 Commentaires)
4.8
BitLabs

Dear sir, I will complete your project asap, LIFETIME error free guarantee and provide ONE YEAR support... I have gone through your outsourced requirement "Fix mysql query help" and have analysed that I have right Plus

20 $ USD en 1 jour
(111 Commentaires)
4.4
techvolcano

Hello, We can help you to build this update query. Give us the db dump. Ready to start now. Thanks.

25 $ USD en 1 jour
(226 Commentaires)
4.5
angnut

Hi, I can give you the query to update all the date field values. you can find my skill and reference on linkedin (angnut) thanks Angelo

20 $ USD en 1 jour
(14 Commentaires)
4.2
atsysinfotech

Hello I have read your requirement and I know how to change the format of date to view in frontend I will need only 20minute to complete the job Thanks

20 $ USD en 1 jour
(7 Commentaires)
4.0
emransl

Query is ready, inform me if required. .................................................................

10 $ USD en 0 jours
(20 Commentaires)
3.9
nojnish

Hi, I can help you with the query to update the values as you want. I understand you want to put previous date in the column leaving the hours-min part of the existing value. is this correct? please let me k no Plus

15 $ USD en 1 jour
(2 Commentaires)
3.6
xpoh

Hello! Your query will be ready as soon as u contact me. So do not waste your time just go ahead. p.s: Now it's going nothimg matter text coz freelancers requires length of proposion at least 100 chars :)

10 $ USD en 0 jours
(10 Commentaires)
3.4
money800

Hello my friend, I am an expert in SQL, you can see from my freelancer exam, I got 100%. I have been working with database for the past 15 years. I am bidding the minimum possible amount for this project as I want t Plus

10 $ USD en 0 jours
(8 Commentaires)
2.8