Re: Unix Timestamp

[Owen DeLong <owen () delong sj ca us>]

"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