[no subject]

I thought I had some answers, but there's a slight discrepency:

perl -e 'use POSIX; print mktime(0,0,12,14,4-1,2004-1900,0,0,0), "\n";'
1081962000

mysql> SELECT unix_timestamp('2004-4-14 12:00:00');
+--------------------------------------+
| unix_timestamp('2004-4-14 12:00:00') |
+--------------------------------------+
|                           1081958400 |
+--------------------------------------+

YMMV :D

-- Jason


</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<!--X-Follow-Ups-End-->
<!--X-References-->
<ul><li><strong>References</strong>:
<ul>
<li><strong><a name="01168" href="msg01168.html">[ale] PERL + SQL Dates</a></strong>
<ul><li><em>From:</em> cfowler at outpostsentinel.com (Chris Fowler)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg01170.html">[ale] PERL + SQL Dates</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg01172.html">[ale] snmptrapsd reporting, um, er - flawed logic</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg01170.html">[ale] PERL + SQL Dates</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg01173.html">[ale] PERL + SQL Dates</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#01171"><strong>Date</strong></a></li>
<li><a href="threads.html#01171"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

<!--X-BotPNI-End-->
<!--X-User-Footer-->
<!--X-User-Footer-End-->
</body>
</html>