Computing.Net > Forums > Web Development > mySQL puzzle

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

mySQL puzzle

Reply to Message Icon

Name: siepmann
Date: August 9, 2005 at 09:42:18 Pacific
OS: Fedora
CPU/Ram: Athlon 2200/512
Comment:

So here's a mySQL puzzle for you. I have a single field of type datetime. Is there a way, in an update query, to change the time part, but leave the date part alone?!

Peter



Sponsored Link
Ads by Google

Response Number 1
Name: siepmann
Date: August 9, 2005 at 10:10:07 Pacific
Reply:

Solved my own question:

set date = concat(date(date), ' 10:30:00')


0
Reply to Message Icon

Related Posts

See More


Resizing images PHP and POST



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Web Development Forum Home


Sponsored links

Ads by Google


Results for: mySQL puzzle

Php/mySql/Phorum problems www.computing.net/answers/webdevel/phpmysqlphorum-problems/932.html

How do I setup PHP & MySQL on XP www.computing.net/answers/webdevel/how-do-i-setup-php-amp-mysql-on-xp/122.html

asp.net web service and mysql www.computing.net/answers/webdevel/aspnet-web-service-and-mysql-/2695.html