|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
July 3rd, 2003, 09:59 AM
|
|||
|
|||
|
Date Arithmetic With MySQL
Date Arithmetic With MySQL
2003-07-03 - When dealing with date and time values, one of the more common (and complex) tasks involves performing addition and subtraction operations on these values. However, with MySQL's powerful date and time API taking care of all the minor adjustments for you, manipulating date and time data is no longer the tedious and time-consuming process it used to be. Find out why, inside. Please discuss this article in this thread You can read the article here .
|
|
#2
July 6th, 2003, 02:53 AM
|
|||
|
|||
|
Also consider the MySQL Manual:
http://www.mysql.com/doc/en/Date_and_time_types.html http://www.mysql.com/doc/en/Date_an..._functions.html Also keep in mind the SQL "AS" statement because you'll most likely be using it. For example: SELECT foo, UNIX_TIMESTAMP(somedatecolumn) AS utimestamp FROM sometable This way you can access it by the name utimestamp. Last edited by Philip Olson : July 6th, 2003 at 02:58 AM.
|
|
| Viewing: Dev Shed Forums > Other > Development Articles > Date Arithmetic With MySQL |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
