|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
|
You eat, breathe and sleep innovation. Build your mobile intelligence with BlackBerry® experts this July. Register Today! |
|
#1
October 5th, 2003, 03:30 PM
|
|||
|
|||
|
mySQL Date Fucntion
Hey,
I was working on a mysql databse which has all dates for a particular month. Is there a way in which I can get the date to auto_increment when I insert a record? Say today is 2003-10-05 when I insert a ew record, the date should be 2003-10-06. Is there any way I can do it in mySQL?
|
|
#2
October 5th, 2003, 03:35 PM
|
|||
|
|||
|
RE: mySQL Date Fucntion
No I don't think.
|
|
#3
October 5th, 2003, 05:52 PM
|
|||
|
|||
|
RE: mySQL Date Fucntion
you can use the DATE_ADD function of MySQL to accomplish this... consult the MySQL manual for more information on all the date functions available in MySQL (there are lots!!) You could also add 1 day to the date using php (I am assuming you are coding in php) before inserting the date into the DB...There are several ways to handle this check out all the PHP and MySQL date functions.
|
|
| Viewing: Codewalkers Forums > Other Technologies > Database Help > mySQL Date Fucntion |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
