Re: Solutions for 1970 epoch date restriction
| From: | John W. Holmes | Date: | Sun, 09 Nov 2003 19:58:32 +0000 |
| Subject: | Re: Solutions for 1970 epoch date restriction | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-168994@lists.php.net to get a copy of this message | ||
YC Nyon wrote:
I have a table that includes 3 columns for day, month and year. Example: Day, Month, Year 11,Jan, 1974 4,Sep, 1921 ... ... I need to construct a query where users can specify a starting date. Currently, I stuck in mktime function became of the 1970 epoch problem. It gives an error for dates before 1970. Anyone has a solution?Why are you using three separate columns? What database are you using? -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals – www.phparch.com