big problem quick solution I hope

[krappleby025]

hi all,

i am trying to enter a date into a mysql database with a field setting of Datetime,

Now this is easy to do when i use the NOW() command, however i need to add a date for one months time..

so instead of 28 dec it would be 28 jan

any ideas

thanks

 

[MJB3K]

NOW()+1 but not tested

Regards,

Martin

Gaming Help And Info:

http://gaming.webrevolt.biz

 

[krappleby025]

didnt work.. lol

thanks

 

[cLFlaVA]

what version of MySQL are you using?

You could try:

INSERT INTO tbl_name VALUES ( DATE_ADD( NOW(), INTERVAL 1 DAYS ) );

*cLFlaVA
----------------------------
[tt]Sigs cause cancer.[/tt]

 

[cLFlaVA]

Sorry, should be:

INSERT INTO tbl_name VALUES ( DATE_ADD( NOW(), INTERVAL 1 [red]MONTHS[/red] ) );

*cLFlaVA
----------------------------
[tt]Sigs cause cancer.[/tt]

 

[krappleby025]

hasnt worked

 

[cdlvj]

You tried string in either 'YYYY-MM-DD HH:MM:SS' or 'YY-MM-DD HH:MM:SS'

 

[cLFlaVA]

check the mysql forum. and answer questions people ask. like "what version are you using?"

*cLFlaVA
----------------------------
[tt]Sigs cause cancer.[/tt]

 

[krappleby025]

i dont know what version im using.. but i managed to solve the problem, using a different method than you all posted.. thanks for your help

 

[ingresman]

it's customary to share your solution, also if you start up mysql command line processor (mysql) it tells you the version your on.