Gossamer Forum: General: Databases and SQL: Re: [mdj1] Inserting A Date into MySQL: Edit Log

Gossamer Threads

Home : General : Databases and SQL :

General: Databases and SQL: Re: [mdj1] Inserting A Date into MySQL: Edit Log

Here is the list of edits for this post

Sep 21, 2003, 8:55 PM

lanerj

User (304 posts)

Sep 21, 2003, 8:55 PM

Re: [mdj1] Inserting A Date into MySQL

This is not a perl question, but anyway.

You will need to use the mySQL DATE_ADD() function, something like -
DATE_ADD(domain_date,domain_period_yr YEAR)
or you could use NOW() instead of domain_date which would give you 2 years from todays date, but I think in this case you need to use domain_date as the date reference.

Bob
http://totallyfreeads.com.au

Last edited by:

lanerj: Sep 21, 2003, 9:03 PM

Edit Log:

Post edited by lanerj Post edited by lanerj (User) on Sep 21, 2003, 8:59 PM
Post edited by lanerj Post edited by lanerj (User) on Sep 21, 2003, 9:03 PM

Gossamer Threads is a Vancouver-based company with over 28 years experience in web technology. From development to hosting, we partner with leading organizations around the globe and help to build their web presences, strategies and infrastructures.

Let’s talk: 1-877-715-7676