Solutions for 1970 epoch date restriction

Hi,

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?


Regards
Nyon

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

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/...-c20a0526ce0b]