> On Thu, 24 Feb 2005 11:39:41 -0500, Adkins, Randy > <[EMAIL PROTECTED]> wrote: >> Well whichever, MySQL does not have that functionality. >> I wish it did. But still, I do enjoy using MySQL rather >> than MS-SQL. But that is my personal choice
> Actually, MySQL has an entire field type for handling > timestamps > (TIMESTAMP) that autopopulates on create and then > optionally again on > every update, depending on how you write the query. > Of course that makes your code a bit less portable. Iirc "timestamp" is the official standard name for date/time data types in SQL databases... MS SQL is abberant in using the name "datetime" or "smalldatetime". s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196337 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54