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 :
( 107 commentaires ) Lüneburg, Germany

N° du projet : #8493229

57 freelance font 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
(849 Commentaires)
8.4
sprextech

----------------------------------------------------------Please Consider on My BID---------------------------------------------------Hello Sir, I have 7 + years experience of web site development. Expert in Custom Cor Plus

28 $ USD en 1 jour
(274 Commentaires)
7.4
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
(271 Commentaires)
6.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
(115 Commentaires)
6.7
AndrewYer

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

10 $ USD en 0 jours
(188 Commentaires)
6.4
sat12

Hi, i will start right now and do it like you said. it is y-m-d H:i:s I am joomla, virtuemart expert having 5 years of experience... recently i completed these projects [url removed, login to view] [url removed, login to view] Plus

15 $ USD en 1 jour
(332 Commentaires)
6.7
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)
6.6
codinglover89

Please use SQL below: ##################################### UPDATE imagefound SET first_found = '2015-09-16 00:00:00' ##################################### Please use above command and check by yourself After Plus

10 $ USD en 1 jour
(21 Commentaires)
6.0
l4logics

Hii Simple Update Query for this fields Can i do for this.? I will do this work very easily , no worry Thanks

10 $ USD en 1 jour
(108 Commentaires)
6.2
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
(85 Commentaires)
5.9
yamandhuliye

hi, i can easily do this work. i can easily update your datetime field. You can just provide me table for which i have to update.

12 $ USD en 0 jours
(110 Commentaires)
5.9
wrarvw

Hello. I have a lot of experience with SQL and MySQL and I think your task can be done in short time.

20 $ USD en 1 jour
(33 Commentaires)
5.7
UmidKZ

Hello, thank you for posting this project. Experienced PHP developer, ready to start immediately. Regards, Umid

15 $ USD en 0 jours
(29 Commentaires)
5.2
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
(41 Commentaires)
5.1
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
(25 Commentaires)
4.7
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.4
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
hellocp150

Hi let's do it now i have more than 5 years of exp in core php and mysql i will do it as per your requirements thanks

34 $ USD en 1 jour
(46 Commentaires)
4.7