Re: Solutions for 1970 epoch date restriction
| From: | David Otton | Date: | Sun, 09 Nov 2003 23:59:55 +0000 |
| Subject: | Re: Solutions for 1970 epoch date restriction | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-168999@lists.php.net to get a copy of this message | ||
On Mon, 10 Nov 2003 01:41:15 +0800, you wrote:
>I have a table that includes 3 columns for day, month and year. Example:
>Day, Month, Year
>11,Jan, 1974
>4,Sep, 1921
That would be your problem - you should be using your database's native date
type.
>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?
[assumes mysql]
http://www.mysql.com/doc/en/Date_and_time_types.html
SELECT * FROM table WHERE start_date > '1969-08-25';
[for anyone who's interested, Raymond Chen's excellent journal had a short
article on various Windows timestamps:
http://blogs.gotdotnet.com/raymondc/permalink.aspx/99c54993-5c5e-45b9-95c1-c20a0526ce0b]