[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[no subject]
- <!--x-content-type: text/plain -->
- <!--x-date: Tue Mar 2 11:05:03 2004 -->
- <!--x-from-r13: wnzrf ng fhzaref.ngu.pk (wnzrf ng fhzaref.ngu.pk) -->
- <!--x-message-id: [email protected] -->
- <!--x-reference: 1078240864.23190.25.camel@devel --> "http://www.w3.org/TR/html4/loose.dtd">
- <!--x-subject: [ale] MySQL dates -->
- <li><em>date</em>: Tue Mar 2 11:05:03 2004</li>
- <li><em>from</em>: james at sumners.ath.cx (james at sumners.ath.cx)</li>
- <li><em>in-reply-to</em>: <1078240864.23190.25.camel@devel></li>
- <li><em>references</em>: <1078240864.23190.25.camel@devel></li>
- <li><em>subject</em>: [ale] MySQL dates</li>
On Tue, Mar 02, 2004 at 10:21:05AM -0500, Chris Fowler wrote:
> What is the best way to store dates in a datebase? I'm currently
> storing them as the a string of output from the date command. That
> becomes a problem when I do an order by date and select based on date.
> I would like to store them so I can order them correctly and also do
> a select by date. To generate reports. I'm using perl to generate all
> reports.
>
> Thanks,
> Chris
>
>
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> <a rel="nofollow" href="http://www.ale.org/mailman/listinfo/ale">http://www.ale.org/mailman/listinfo/ale</a>
--
I used to be interested in Windows NT, but the more I see of it the more it looks like traditional Windows with a stabler kernel. I don't find anything technically interesting there. In my opinion MS is a lot better at making money than it is at making good operating systems. -- Linus Torvalds
</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="00039" href="msg00039.html">[ale] MySQL 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="msg00042.html">[ale] MySQL dates</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00044.html">[ale] OT: One time use Digital cameras</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00042.html">[ale] MySQL dates</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00046.html">[ale] Hokki =)</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00043"><strong>Date</strong></a></li>
<li><a href="threads.html#00043"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>
<!--X-BotPNI-End-->
<!--X-User-Footer-->
<!--X-User-Footer-End-->
</body>
</html>