Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

date maniulation in MySQL

Status
Not open for further replies.
ssudha17

ssudha17

Programmer
Feb 20, 2001
21
US
Hi,
I wish to add hours and minutes to a date field and determine the resultant date. For example, if I add 8hours 15 minutes to a date field say 03/12/2001 23:10:10, i should be able to get 03/13/2001 07:25:10 as the resultant. I am using Java as frontend.Can I do this manipulation at the query level itself?
Thanks and regards,
Sudhakar Visit to know more about my achievements
 
Status
Not open for further replies.

Similar threads

lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
262
lupidol
lupidol
dylim
  • Locked
  • Question
SQL_CALC_FOUND_ROWS still runs in MySQL 8.0.29
Replies
2
Views
287
dylim
dylim
lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
232
Chris Miller
Chris Miller
dylim
  • Locked
  • Question
Why MySQL 5.7 is still getting updates
Replies
3
Views
168
spamjim
spamjim
soushi01
  • Locked
  • Question
MySQL replication slave server re-sync issue
Replies
0
Views
154
soushi01
soushi01

Part and Inventory Search

Sponsor

Back
Top