"Greg A. Woods" wrote:
[ On Monday, October 22, 2001 at 18:18:41 (-0500), Chris Adams wrote: ]
Subject: Re: Unix Timestamp
On Red Hat Linux 7.1: $ date -r 1003723200 date: 1003723200: No such file or directory
The first two were kinda sad examples of the state of commercial Unix (unfortunately even SuSv2 lacks this now ancient feature!), but this last one (i.e. GNU date) surprises the heck out of me -- especially since there's not even an equivalent option with a different name....
But perl works on all three. :-)
So does the gawk variant, and so would a silly one-line C program. No doubt python and ruby variants would be equally portable. I really hate perl. It is the worst of all the bad interpreted languages. Well maybe not as bad as VB....
But enough of this nonsense -- the best answer is the one from Michael Barrow to just use FROM_UNIXTIME() in the MySQL code directly.
-- Greg A. Woods
+1 416 218-0098 VE3TCP <gwoods@acm.org> <woods@robohack.ca> Planix, Inc. <woods@planix.com>; Secrets of the Weird <woods@weird.com>
Hmmm... How exactly does one use a MySQL builtin inside an M$ SQL database? Owen -- *********************************************************************** "Every time you turn on your new car, you're turning on 20 microprocessors. Every time you use an ATM, you're using a computer. Every time I use a settop box or game machine, I'm using a computer. The only computer you don't know how to work is your Microsoft computer, right?" - Scott McNealy, CEO of Sun Microsystems, Inc., from an April 1997 interview in Upside Magazine *********************************************************************** "One World, One Web, One Program." - Microsoft Promotional Ad "Ein Volk, Ein Reich, Ein Führer" - Adolf Hitler